A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Types of Triggers

DDL Statements
DDL Statements

What is DDL Trigger? Data Definition Language (DDL) Triggers are special kind of Stored Procedure or an operation that gets executed automatically when a DDL Statements like CREATE, ALTER, DROP, GRANT, DENY, REVOKE, and UPDATE STATISTICS statements are executed.

source: sqlhints.com
User Events Such as Logon and Logoff
User Events Such as Logon and Logoff

Unlike logon database event trigger which fires after a valid logon attempt by a user on the database, logoff triggers execute before the user logs off from the database. Logoff trigger can be proved as a versatile tool for a DBA as well as for a database user.

Related Question Categories