What are Magic Table?
Answer Posted / danish aleem
An implicit trigger is fired when ever we insert, update or delete, then the two temporary tables are created i.e.insert and delete. So these temporary tables are termed as MAGIC TABLES.
* These are named as MAGIC because they are removed automatically when the specified query is committed.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is hot add cpu in sql server 2008?
What is a print index?
What are .mdf files?
how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration
Differentiate between a primary key and a unique key.
what's the difference between a primary key and a unique key? : Sql server database administration
We need to perform what steps in the following order to work with a cursor?
Why we use functions in sql server?
Explain the architecture of ms sql reporting service?
What is function of master database?
What is cte (common table expression)?
What is the difference between rank and dense_rank?
What is difference between count (*) and count 1?
What is the purpose of optimization?
Explain concepts of analysis services?