I have two schema. Schema1 and Schema2
How would I transfer all the tables from schema1 to schema2?
Execute this for all of the tables:
To programmatically get the statements to execute:
Assuming destination schema is empty:
If the destination schema is not empty, you'll need additional handling for conflicts.