Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Azure SQL DATABASE Syntax
- -- Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger)
- CREATE [ OR ALTER ] TRIGGER [ schema_name . ]trigger_name
- ON { TABLE | VIEW }
- [ WITH <dml_trigger_option> [ ,...n ] ]
- { FOR | AFTER | INSTEAD OF }
- { [ INSERT ] [ , ] [ UPDATE ] [ , ] [ DELETE ] }
- AS { sql_statement [ ; ] [ ,...n ] [ ; ] > }
- <dml_trigger_option> ::=
- [ EXECUTE AS Clause ]
- GET link:https://ouo.io/FXetB9
Add Comment
Please, Sign In to add comment