What are Magic Table?
- 34 Answers
- 73787 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / sharda prasad shukla
MAGIC TABLES NOTHING BUT INSERTED AND DELETED WHICH ARE
TEMPORARY OBJECTS CREATED BY SERVER INTERNALLY TO HOLD
RECENTLY INSERTED VALUES IN THE CASE OF INSERT,TO HOLD
RECENTLY DELETED VALUES IN THE CASE OF DELETE,TO HOLD
BEFORE UPDATING VALUES OR AFTER UPDATING VALUES IN THE CASE
OF UPDATE.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Explain the use of keyword with encryption. Create a store procedure with encryption?
How do I find information about the install locations for the various instances running on a computer?
What are the dmvs?
What is a trace frag?
What are the new security features added in sql server 2012? : sql server security
How many types of the database links?
Explain powershell included in sql server 2008?
What is the difference between SQL notification and SQL invalidation?
What types of replication are supported in sql server?
What happens if you delete a table that is used by a view?
Where cross join is used?
How can we delete Duplicate row in table?
What is the difference between clustered and a non-clustered index?
Should you normalize audio?
How is a full-text index updated?
