What are Magic Table?
- 34 Answers
- 73467 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
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
How to modify existing triggers using "alter trigger"?
What happens if you delete a table that is used by a view?
How to see existing views in ms sql server?
Explain about remote stored procedure?
What is indexed view? How to create it?
Explain unique key in sql server?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is the partitioning method?
What is a filestream?
How to throw custom exception in Stored Procedure?
Explain transaction server implicit?
What is the difference between varchar and nvarchar datatypes?
How to provide values to user defined function parameters?
What are statistics?
 Explain what is sql override for a source taLle in a mapping?
