Introduction to DDL triggers
It is a new trigger in Sql Server2005, which is mainly used to review and standardize the operations on the tables, triggers, views and other structures in the database. For example, in modifying tables, modifying columns, adding tables, adding columns, etc. It is executed when the database structure changes. We mainly use it to record the database modification process and to restrict programmers from modifying the database, such as not allowing certain tables to be deleted.