Monday , December 11 2017
Home / DataBase / SQL SERVER / step by step Procedure for Creating DDL Triggers (Part-1)

step by step Procedure for Creating DDL Triggers (Part-1)

DDL triggers:

DDL triggers fire in response to a variety of Data Definition Language (DDL) events. These events primarily correspond to Transact-SQL statements that start with the keywords CREATE, ALTER, DROP, GRANT, DENY, REVOKE or UPDATE STATISTICS.

DDL triggers are fired when user performs DDL events(CREATE,ALTER and DROP) in the database. we can define triggers on the current database.

see more for creating DDL Triggers step step by Step

 

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: