sp_helptrigger returns list of DML trigger created on specific table on currect database. It cannot be retrived DDL triggers.
Syntax:
- sp_helptrigger [ @tabname = ] [ , [ @triggertype = ] 'type' ]
Example:- Use TestDB
- exec sp_helptrigger 'dbo.TestTable'