T-SQL Tutorial

T-SQL sp_helptrigger

On Transact SQL language the sp_helptrigger is part of Database Engine Stored Procedures.
Returns the type or types of DML triggers defined on the specified table for the current database. sp_helptrigger cannot be used with DDL triggers.

sp_helptrigger syntax:

sp_helptrigger [ @tablename = ] 'table'
[ , [ @triggertype = ] 'type' ]

sp_helptrigger example:

USE model;
EXEC sp_helptrigger 'Customers';