What is a DDL trigger in SQL?
What is a DDL trigger in SQL? SQL Server DDL triggers are specifically used to control and review the changes taking place in the database. These triggers can be used to put the limit on the unauthorized clients to make DDL type of changes such as DROP VIEW, DROP PROCEDURE, DROP Function and so on using DDL Trigger. Can we use DDL in trigger? DDL triggers fire only after the DDL statements that trigger them are run. DDL triggers cannot be used as INSTEAD OF triggers. Is trigger DDL or DML? What is the difference between a DDL trigger and...