Displays the trigger SQL definition (if the trigger is not encrypted) : sys.sql_modules « System Tables Views « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Tables Views
3. sys.sql_modules

4>
5> SELECT o.name, m.definition
6> FROM sys.sql_modules m
7> INNER JOIN sys.objects o ON
8> m.object_id = o.object_id
9> WHERE o.type = 'TR'
10> GO
name
         definition


------------------------------------------------------------------------------------------------------------------------
-------- ---------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------
-------------------------
1>