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, 1944🔥, 0💬
Popular Posts:
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...