1.

What Are Ddl Triggers And Types Of Ddl Trigger?

Answer»

DDL triggers FIRE in response to an event happening on the server. HOWEVER, DDL triggers do not fire in response to UPDATE, INSERT, or DELETE (DML) statements on a table or view. Instead, they fire in response to Data Definition Language (DDL) statements that start with the KEYWORDS CREATE, ALTER, and DROP.

DDL triggers you can categorize:

  • Transact-SQL DDL Trigger
  • CLR DDL Trigger

DDL triggers fire in response to an event happening on the server. However, DDL triggers do not fire in response to UPDATE, INSERT, or DELETE (DML) statements on a table or view. Instead, they fire in response to Data Definition Language (DDL) statements that start with the keywords CREATE, ALTER, and DROP.

DDL triggers you can categorize:


Discussion

No Comment Found

Related InterviewSolutions