sys.triggers « System Tables Views « SQL Server / T-SQL Tutorial






27.19.sys.triggers
27.19.1.Viewing DDL Trigger Metadata by querying sys.triggers
27.19.2.Viewing DML Trigger Metadata: Show the DML triggers in the current database
27.19.3.Viewing DDL Trigger Metadata by joining sys.triggers and sys.sql_modules