This topic has not yet been rated - Rate this topic

ALTER TRIGGER (Windows Azure SQL Database)

Changes the definition of a data manipulation language (DML) or data definition language (DDL) trigger.

Syntax Conventions (Windows Azure SQL Database)

Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger) 
ALTER TRIGGER schema_name .trigger_name 
ON ( table | view ) 
[ WITH <dml_trigger_option> [ ,...n ] ]
( FOR | AFTER | INSTEAD OF ) 
{ [ DELETE ] [ , ] [ INSERT ] [ , ] [ UPDATE ] } 
AS { sql_statement [ ; ] [ ...n ] } 

<dml_trigger_option> ::=
    [ <EXECUTE AS Clause> ]

Trigger on a CREATE, ALTER, DROP, GRANT, DENY, REVOKE, or UPDATE statement (DDL Trigger)

ALTER TRIGGER trigger_name 
ON { DATABASE } 
[ WITH <ddl_trigger_option> [ ,...n ] ]
{ FOR | AFTER } { event_type [ ,...n ] | event_group } 
AS { sql_statement [ ; ] }
 } 

<ddl_trigger_option> ::=
    [ <EXECUTE AS Clause> ]

Arguments

This syntax diagram shows the supported arguments and options in Microsoft Windows Azure SQL Database.

Windows Azure SQL Database does not support triggers on login events. Therefore, you cannot alter the definition of login triggers.

Windows Azure SQL Database does not support the following arguments and options with the ALTER TRIGGER statement:

ALL SERVER for DDL triggers
ENCRYPTION
EXECUTE AS LOGIN
EXTERNAL NAME
NOT FOR REPLICATION

For more information about Windows Azure SQL Database support for the EXECUTE AS statement, see EXECUTE AS (Windows Azure SQL Database).

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

ALTER TRIGGER (Windows Azure SQL Database)

Reference

Concepts

Other Resources

Community Additions