After insert audit trigger
SQL
Easy
0 views
Problem Description
After inserting into Orders, insert a row into AuditLog(table_name, row_id, action).
Output Format
Trigger created
Constraints
AuditLog exists
Official Solution
CREATE TRIGGER trg_orders_audit AFTER INSERT ON Orders FOR EACH ROW INSERT INTO AuditLog(table_name, row_id, action) VALUES ('Orders', NEW.order_id, 'INSERT');
Solutions (0)
No solutions submitted yet. Be the first!
No comments yet. Start the discussion!