Get all trigger(s) from Database in SQL

 

Simple way to get all triggers exist into the database.
 below query show all trigger(s) into the database

SELECT a.[name] AS TriggerName, b.[name] AS TableName 
FROM sys.triggers a join sys.tables b ON a.parent_id = b.object_id

Simple query to get all trigger from the database