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, 3233🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How Many Groups of Data Types in MySQL? MySQL support 3 groups of data types as listed below: String...
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the on...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...