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, 2532🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...