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, 2276🔥, 0💬
Popular Posts:
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...