get-information-about-ddl-triggers.md

title	description	author	ms.author	ms.date	ms.service	ms.topic	helpviewer_keywords	monikerRange
Get Information About DDL Triggers	Get Information About DDL Triggers	MikeRayMSFT	mikeray	03/06/2017	sql	conceptual	metadata [SQL Server], triggers status information [SQL Server], DDL triggers DDL triggers, metadata	=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Get Information About DDL Triggers

[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] 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