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.