user3005090
Reputation: 1
Tracking a trigger from a dropped table
I have dropped a table which contains a trigger. Is it possible to view or track the trigger of the dropped table. Thanks in advance
Upvotes: 0
Views: 26
Answers (1)
Radhamani Muthusamy
Reputation: 328
Once the Tableis dropped, there is no way to view or get the trigger. I could not add as a comment so adding it as an answer.
Upvotes: 1
Related Questions
- How to get the action performed in trigger
- Get the inserted row causing the execution of the trigger
- How to find trigger that stopping a table to be dropped
- Create Trigger to log SQL that affected table?
- SQL Server trigger to drop another database
- Relation between Inserted and Deleted table's in a trigger
- Logging update operation in triggers
- SQL Server - How to copy data from dropped table when DROP_TABLE TRIGGER fires after table is dropped?
- Logging SQL that caused a trigger
- See what caused a SQL trigger?