3
Reply

What are magic tables in SQL and how can we use them?

Chetana Barot

Chetana Barot

7y
364
0
Reply

    when we use trigger inserted and deleted data are stored in temporary table those table are called magic tables

    two Magic Tables SQL(Trigger)Inserted Deleted

    Magic tables are internal tables in SQL and we can use them through triggers only. Refer this link for detailed answer: http://www.c-sharpcorner.com/UploadFile/rohatash/magic-tables-in-sql-server-2012/