--How to track DML Changes using Triggers
--1. After triggers
select * from employee
--AUDIT_TABLE
--CREATE AUDIT TABLE
CREATE TABLE AUDIT_TABLE(TABLENAME VARCHAR(20), OPERATION VARCHAR(10), OPERATIONDATE DATE)
--CREATE TRIGGER FOR INSERT
--CREATE TRIGGER FOR UPDATE
--CREATE TRIGGER FOR DELETE
CREATE OR ALTER TRIGGER TR_AFTERDELETE
ON EMPLOYEE FOR DELETE
AS
BEGIN
INSERT INTO [AUDIT_TABLE](TABLENAME,OPERATION,OPERATIONDATE)
VALUES('EMPLOYEE','DELETE',GETDATE())
END
--INSERT DATAT TO EMPLOYEE
INSERT INTO EMPLOYEE VALUES(9,'JASON','US')
SELECT * FROM AUDIT_TABLE
--UPDATE DATA
UPDATE EMPLOYEE SET NAME = 'ROBINSON' WHERE ID = 9
--DELETE DATA
DELETE FROM EMPLOYEE WHERE ID=9
