Collections:
"CREATE TRIGGER" - Creating a DDL Trigger in SQL Server
How To Create a DDL Trigger using "CREATE TRIGGER" Statements in SQL Server?
✍: FYIcenter.com
A DDL trigger is defined to handle a DDL statement event, like create, alter and drop tables, views, indexes, etc. DDL triggers can be used to generate warning messages on database object changes. The format of creating a DDL trigger should be:
CREATE TRIGGER trigger_name ON DATABASE AFTER ddl_event_types AS statements GO -- ddl_event_types are keywords like: -- CREATE_TABLE, ALTER_TABLE, DROP_TABLE, ...
Below is a simple example of creating a DDL trigger to generate messages on ALTER_TABLE events:
USE FyiCenterData; GO CREATE TRIGGER ddl_message ON DATABASE AFTER ALTER_TABLE AS PRINT 'Someone is changing tables!'; GO ALTER TABLE fyi_users ALTER COLUMN id INT NOT NULL; GO Someone is changing tables!
⇒ Rolling Back the DDL Statement in a Trigger in SQL Server
⇐ "INSTEAD OF" - Overriding DML Statements with Triggers in SQL Server
2016-10-22, 1495🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...