Viewing a Trigger

Microsoft® SQL Server™ allows you to determine the types of triggers on a table, the name of the trigger, its owner, and the date it was created.

You can also:

• Gain information about the definition of a trigger if it was not encrypted when created or modified. You may need to see the definition of the trigger to see its Transact-SQL statements or to understand how it affects the table upon which it is defined.
• List the objects used by the specified trigger. This information can be used to identify the objects that affect the trigger if they are changed or deleted in the database.

To view the types of triggers on a table

To view information about a trigger

To view a trigger

To view the dependencies of a trigger