CREATE TRIGGER DELETESTUDENT ON Student FOR DELETE AS SELECT * FROM DELETED SELECT * FROM STUDENT WHERE SNO='200513' GO DELETE FROM STUDENT WHERE SNO='200513'