164k views
4 votes
Which of the following triggers are not supported in Azure SQL database?

A. Logon Triggers
B. DML Triggers
C. DDL Triggers

User Heilerich
by
7.6k points

1 Answer

4 votes

Final answer:

In Azure SQL database, Logon Triggers are not supported, whereas DML and DDL Triggers are both supported.

Step-by-step explanation:

The Azure SQL database does not support Logon Triggers. However, it does support both DML Triggers (Data Manipulation Language Triggers) and DDL Triggers (Data Definition Language Triggers). Logon Triggers are usually used to execute a batch of code as a response to a LOGON event, and this type of trigger is not available in Azure SQL databases. DML Triggers are a type of SQL trigger that is fired when data manipulation events take place such as an INSERT, UPDATE, or DELETE on a table or view. DDL Triggers, on the other hand, are fired in response to changes in database schema, such as creating or altering objects like tables, indexes, or procedures.

User Keeda
by
7.6k points