Networking HowTos
Networking HowTos

List all Triggers on a SQL Database

January 2, 2012 Database, Microsoft SQL

Ever wanted to know what triggers exist on a database? The script below will produce a list of all the triggers on the current database, and also what table they are linked to.


SELECT Name AS TriggerName,
OBJECT_NAME(parent_object_id) AS TableName
FROM sys.objects
WHERE type='TR'



You Might Also Like