sql trigger before delete

Solutions on MaxInterview for sql trigger before delete by the best coders in the world

showing results for - "sql trigger before delete"
Veronica
08 Jul 2018
1CREATE TRIGGER TRG_AUD_DEL
2ON yourTable
3FOR DELETE
4AS
5     INSERT INTO my_audit_table  (col1, col2, ...)
6     SELECT col1, col2...
7     FROM DELETED