Sample Header Ad - 728x90

Need to create a duplicate table in a separate schema automatically whenever a new table is being created

0 votes
1 answer
69 views
Whenever a new table is being created in Schema 'A', I need the table to be duplicated in the Schema 'B'. This should happen automatically. I have searched for trigger concept but it wont work on DDL statements like 'CREATE' or 'ALTER' statements. How do I achieve this without triggers? Please help me.
Asked by Edvin Guromin (1 rep)
Mar 20, 2024, 07:25 AM
Last activity: May 27, 2024, 05:52 PM