I have a database with several tables and i have a table which contains all tablenames which I want to alter.
I want to perform a query like this:
ALTER TABLE (SELECT "TABLE_NAME" FROM "RESOURCE_TABLES) DROP COLUMN ID;
My Table RESOURCE_TABLE with Table Names:
TABLE_NAME ID Table1 1 Table2 2 Table3 3 ... ...
How can I alter all tables named in the table in the column TABLE_NAME with a loop or a query?
So i want Table1,Table2,Table3 to drop a column id without executing a single alter table query on each table because maybe the tables are 100 Tables.