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, 1580🔥, 0💬
Popular Posts:
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...