sys.sp_helptrigger

Description

Returns the type or types of data manipulation language (DML) triggers defined on the specified table for the current database. can’t be used with data definition language (DDL) triggers. Query the The name of the table in the current database for which to return trigger information. The type of DML trigger to return information about.

Syntax

sp_helptrigger
[ @tabname = ]
N
'tabname'
[ , [ @triggertype = ]
'triggertype'
]
[ ; ]