The syntax of the ALTER TRIGGER statement : Alter Trigger « Trigger « SQL Server / T-SQL Tutorial






ALTER TRIGGER trigger_name
ON {table_name|view_name}
[WITH ENCRYPTION]
{FOR|AFTER|INSTEAD OF} [INSERT] [,] [UPDATE] [,] [DELETE]
AS sql_statements








22.2.Alter Trigger
22.2.1.The syntax of the ALTER TRIGGER statement
22.2.2.ALTER a TRIGGER
22.2.3.Modifying a Trigger
22.2.4.Auditing Triggers