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 a collation?
What are the differences between ms sql server & oracle?
How will you monitor replication latency in transactional replication? : sql server replication
What are horizontal and vertical scaling?
How to insert and update data into a table with "insert" and "update" statements?
What is the main purpose of having conversation group?
What is the difference between Clustered and Non-Clustered Index?
When would you use the stored procedures or functions?
What are subquery and its properties?
Tell me something about security and sql azure?
How can you know if the row fetched from cursor is still valid in underlying table?
How do you check sql server is up and running?
How to use order by with union operators in ms sql server?
What is the difference between set and select?
Why do you want to join software field as you have done your BE in Electronics?