There are Magic Tables (virtual tables) in SQL Server that hold the temporal information of recently inserted and recently deleted data in the virtual table. INSERTED and DELETED are two types of magic tables in SQL Server.
Sandhya Answered question
- Magic Tables are invisible tables or virtual tables.
- You can see them only with the help of Triggers in the SQL Server.
- Magic Tables are those tables that allow you to hold inserted, deleted and updated values during insert, delete and update DML operations on a table in SQL Server.
Shathana. S.R. Answered question