Magic table is the terminology used
for virtual table in SQL Server.
Virtual table holds recently inserted,
deleted and updated values during DML operations (insert, delete & update)
performed on a database table.
This table automatically created and
managed by SQL server internally.
There is two type of virtual table
- Inserted
- Deleted
Use of virtual tables
Basically, virtual tables are used by
triggers
- Inserted virtual table - The inserted table holds the recently inserted or updated values. It means new data values.
- Deleted virtual table -The Deleted table holds the recently deleted or updated values. It means old data values.
No comments:
Post a Comment