.

Also asked, what happens to trigger when table is dropped?

That's if the table the trigger is against is dropped. Your trigger is weird, it's inserting into the same table. In that case, dropping the backup table would invalidate the trigger on the live table, but would not drop it. Only dropping the live table would drop the trigger on the live table.

does dropping a table drop the index SQL Server? By default, MS Sql Server also drops indexes when a table is dropped. (Observed in version 13.0. 4206.0.) DROP TABLE always removes - 1.

Considering this, is synonym dropped when table is dropped?

2 Answers. Dropping a table invalidates objects which have a dependency on the table: those views, synonyms and procedures are not dropped but cannot be used until we intervene to make them compile (e.g. by editing the source code).

When table is dropped what all is dropped?

Dropping a table removes the table definition from the data dictionary. All rows of the table are no longer accessible. All indexes and triggers associated with a table are dropped. All views and PL/SQL program units dependent on a dropped table remain, yet become invalid (not usable).