Collections:
sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server?
✍: FYIcenter.com
If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers.
The sys.sql_modules holds trigger definitions identifiable by the object id of each trigger. The tutorial exercise below shows you how to retrieve the definition of trigger, "dml_message" by joining sys.sql_modules and sys.triggers:
USE FyiCenterData; GO SELECT m.definition FROM sys.sql_modules m, sys.triggers t WHERE m.object_id = t.object_id AND t.name = 'dml_message'; GO definition ------------------------------------------------- CREATE TRIGGER dml_message ON fyi_users AFTER INSERT, UPDATE, DELETE AS PRINT 'Time: '+CONVERT(VARCHAR(12),GETDATE()); PRINT 'Records are inserted, updated,' + ' or deleted in fyi_users'; (1 row(s) affected)
⇒ "DISABLE TRIGGER" - Disabling Triggers in SQL Server
⇐ "DROP TRIGGER" - Deleting Existing Triggers in SQL Server
2016-10-24, 2196🔥, 0💬
Popular Posts:
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...