Collections:
sys.triggers - Listing All Triggers in the Database in SQL Server
How To List All Triggers in the Database with sys.triggers in SQL Server?
✍: FYIcenter.com
If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example:
USE FyiCenterData; GO CREATE TRIGGER new_user ON fyi_users AFTER INSERT AS PRINT 'New users added.'; GO SELECT * FROM sys.triggers GO name object_id parent_id type type_desc ------------ ----------- ----------- ---- ------------ dml_message 690101499 674101442 TR SQL_TRIGGER new_user 706101556 674101442 TR SQL_TRIGGER
The result shows that there are 2 triggers defined in FyiCenterData.
⇒ "ALTER TRIGGER" - Modifying Existing Triggers in SQL Server
⇐ Testing DML Triggers in SQL Server
2016-10-25, 1870🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...