I am deleting a row from a table say student table. I am writing a trigger which will insert the details related to the deleted row in another table say student_log table.
Now I want to store the details related to RollNo, Date when the the student was deleted.
RollNo (int/PK), FName, LName
id (int/PK), date_deleted, RollNo(PK of Student table)
Thanks in Advance.