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, 2105🔥, 0💬
Popular Posts:
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...