get-information-about-ddl-triggers.md

title	Get Information About DDL Triggers | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
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
monikerRange	=azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

Get Information About DDL Triggers

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md] 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