get-information-about-ddl-triggers.md

title	Get Information About DDL Triggers | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology
ms.topic	conceptual
helpviewer_keywords	metadata [SQL Server], triggers status information [SQL Server], DDL triggers DDL triggers, metadata
ms.assetid	462becea-292a-4b9e-bb98-533e89733911
author	rothja
ms.author	jroth
manager	craigg

Get Information About DDL Triggers

The catalog views listed in this section can be used to get information about DDL Triggers.

To get information about the events or event groups on which a DDL trigger can fire.

• sys.trigger_event_types (Transact-SQL)

To view the dependencies of a trigger

• sys.sql_expression_dependencies (Transact-SQL)

• sys.dm_sql_referenced_entities (Transact-SQL)

• sys.dm_sql_referencing_entities (Transact-SQL)

Database-Scoped DDL Triggers

To get information about database-scoped triggers

• sys.triggers (Transact-SQL)

To get information about database events that fire triggers

• sys.trigger_events (Transact-SQL)

To view the definition of a database-scoped trigger

• sys.sql_modules (Transact-SQL)

To get information about CLR database-scoped triggers

• sys.assembly_modules (Transact-SQL)

Server-Scoped DDL Triggers

To get information about server-scoped triggers

• sys.server_triggers (Transact-SQL)

To get information about server events that fire triggers

• sys.server_trigger_events (Transact-SQL)

To view the definition of a server-scoped trigger

• sys.server_sql_modules (Transact-SQL)

To get information about CLR server-scoped triggers

• sys.server_assembly_modules (Transact-SQL)

See Also

DDL Triggers