1-- SQL Server Syntax
2-- Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger)
3
4CREATE [ OR ALTER ] TRIGGER [ schema_name . ]trigger_name
5ON { table | view }
6[ WITH <dml_trigger_option> [ ,...n ] ]
7{ FOR | AFTER | INSTEAD OF }
8{ [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
9[ WITH APPEND ]
10[ NOT FOR REPLICATION ]
11AS { sql_statement [ ; ] [ ,...n ] | EXTERNAL NAME <method specifier [ ; ] > }
12
13<dml_trigger_option> ::=
14 [ ENCRYPTION ]
15 [ EXECUTE AS Clause ]
16
17<method_specifier> ::=
18 assembly_name.class_name.method_name
19
20