Essential Books

Use Trigger to manage a Recycle Bin for deleted items

suggest change 
CREATE TRIGGER BooksDeleteTrigger
    ON MyBooksDB.Books
    AFTER DELETE
AS
  INSERT INTO BooksRecycleBin
    SELECT *
    FROM deleted;
GO
Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

Triggers:
*Triggers
*CREATE TRIGGER
*Use Trigger to manage a Recycle Bin for deleted items
Table Of Contents