Export (0) Print
Expand All

ALTER TRIGGER (Azure SQL Database)

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

ImportantImportant
This topic is not maintained. For the current version, see ALTER TRIGGER (Transact-SQL).

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

Syntax Conventions (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> ]

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

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

Microsoft 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 Microsoft Azure SQL Database support for the EXECUTE AS statement, see EXECUTE AS (Azure SQL Database)

Community Additions

ADD
Show:
© 2014 Microsoft