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
Last activity: May 27, 2024, 05:52 PM