List tables that have Trigger

Asked

Viewed 1,158 times

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.

sql-server trigger

1 answer

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.