Find the triggers in database in sql server

With the help of below sql script we will get the list of trigger in a database

use AdventureWorks2012 SELECT        tbl.name as [Table Name]      , trig.name as [Trigger Name]      , trig.is_disabled FROM [sys].[triggers] as trig INNER JOIN sys.tables as tbl ON trig.parent_id = tbl.object_id

See the example