What are Magic Table?
Answer Posted / shailendra kashyap
Magic Tables:
Whenever a trigger fires in response to the
INSERT,DELETE,or UPDATE statement,two special tables are
created.These are the insert and the delete tables.They are
also referred to as the magic tables.These are the
conceptual tables and are similar in structure to the table
on which trigger is defined(the trigger table).
The inserted table contains a copy of all records that are
inserted in the trigger table.
The deleted table contains all records that have been
deleted from deleted from the trigger table.Whenever any
updation takes place,the trigger uses both the inserted and
deleted tables
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
How to set database to be read_only in ms sql server?
How can we delete a table in sql server?
Disadvantages of the indexes?
What is row_number()?
How to make a column nullable?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
Do you know what are pages and extents? : SQL Server Architecture
What is Cross Join and in which scenario do we use Cross Join?
What are the steps to insert a table?
What are the advantages of mirroring?
explain different levels of normalization? : Sql server database administration
How to connect a database with sql express.?
What is sql server 2000 work load governor?
How is a full-text index updated?
What are the mathematical functions supported by sql server 2005?