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
What happens if null values are involved in arithmetic operations?
How to create a new schema in a database?
What are the properties of the transaction?
What are advantages of ssrs or why we should use ssrs?
Explain the properties of a relational table?
How to verify the port number of the sql server?
How to convert numeric expression data types using the cast() function?
Can a table be created inside a trigger?
What is a sql join?
What is a raid and what are different types of raid configurations?
Can sql server be linked with other servers like oracle?
What are the advantages of user-defined functions over stored procedures in sql server?
What are trace flags?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What is faster join or union?