Interested to Buy Any Domain ? << Click Here >> for more details...
What are Magic Table?
- 34 Answers
- 77666 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
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
Explain index in sql server?
Can group by be used without aggregate functions?
What are the instances when triggers are appropriate?
What are logical database components? : SQL Server Architecture
How to generate create procedure script on an existing stored procedure?
What are commonly used odbc functions in php?
Mention the different types of replication in sql server.
Which command is used for user defined error messages?
How to achieve Paging of records in SQL SERVER?
List types of tables in SQL Azure?
What is the need for group functions in sql?
Explain sub-query?
What is the difference between commit and rollback?
What are alternate keys?
