get-information-about-ddl-triggers.md

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

Get Information About DDL Triggers

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