1
Is there any way to know which tables have at least 1 Trigger ?
For example, I have a system with 10,000 tables, and I would like to know which one has Trigger.
1
Is there any way to know which tables have at least 1 Trigger ?
For example, I have a system with 10,000 tables, and I would like to know which one has Trigger.
2
I found this answer in a question from SOEN, I believe it will solve you:
SELECT t.name AS TableName, tr.name AS TriggerName
FROM sys.triggers tr
INNER JOIN sys.tables t ON t.object_id = tr.parent_id
I understand that the related tables and triggers will be listed; in the answer is added to table as filter, I removed so that all are listed;
Browser other questions tagged sql-server trigger
You are not signed in. Login or sign up in order to post.