Howtos / Articles

List all Triggers on a SQL Database

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'



Share this howto article!
  • Facebook
  • Twitter
  • Reddit
  • email

Leave a Reply




You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>