To display DDL Triggers in your database (SQL Server 2005/2008), use the sys.triggers catalog view as shown below:
-- Database-scoped DDL triggers in the current database
SELECT name as TriggerName, create_date as CreationDate, type_desc as [TriggerType(SQLorCLR)], is_disabled
FROM sys.triggers
WHERE parent_class_desc = 'DATABASE'
ORDER BY name
Read more: SQL Server curry
-- Database-scoped DDL triggers in the current database
SELECT name as TriggerName, create_date as CreationDate, type_desc as [TriggerType(SQLorCLR)], is_disabled
FROM sys.triggers
WHERE parent_class_desc = 'DATABASE'
ORDER BY name
Read more: SQL Server curry