What is the Magic Table in Sql server ?
Ans :- Magic table are the temporary object created by server internally to hold recently inserted value in case of inserted or hold the deleted value in case of deleted or to hold the updated value in case of updated.
Let suppose if we want to create trigger on the table on insert or delete. so on insertion of a record into that table the inserted table will be created automatically by the sql server database, on deletion of record from the table the deleted table will be created automatically by the database
so these 2 table inserted and deleted are called magic table.
these table are not a physical table these are only internal table.
Ans :- Magic table are the temporary object created by server internally to hold recently inserted value in case of inserted or hold the deleted value in case of deleted or to hold the updated value in case of updated.
Let suppose if we want to create trigger on the table on insert or delete. so on insertion of a record into that table the inserted table will be created automatically by the sql server database, on deletion of record from the table the deleted table will be created automatically by the database
so these 2 table inserted and deleted are called magic table.
these table are not a physical table these are only internal table.
No comments:
Post a Comment