List all Triggers on a SQL Database

Ever wanted to know what triggers exist on a database? The script below will produce a list of all the triggers on the current database, and also what table they are linked to.

SELECT Name AS TriggerName,
OBJECT_NAME(parent_object_id) AS TableName
FROM sys.objects
WHERE type='TR'