What are Magic Table?
- 34 Answers
- 80321 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
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is in place upgrade in sql server?
What are different types of constraints?
How can I check that whether automatic statistic update is enabled or not?
How can we solve concurrency problems?
Explain “row_number()” in sql server with an example?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Equi join and non equi join is possible with sql server?
What is a coalesce function?
Can one drop a column from a table?
What is acid mean in sql server?
Explain system functions or built-in functions? What are different types of system functions?
Where can you add custom error messages to sql server?
How to convert numeric expression data types using the cast() function?
How to connect php with different port numbers?
