Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is hot add cpu in sql server 2008?

928


What is a print index?

886


What are .mdf files?

940


how do you implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql server database administration

1064


Differentiate between a primary key and a unique key.

1070


what's the difference between a primary key and a unique key? : Sql server database administration

950


We need to perform what steps in the following order to work with a cursor?

1218


Why we use functions in sql server?

1077


Explain the architecture of ms sql reporting service?

921


What is function of master database?

114


What is cte (common table expression)?

1032


What is the difference between rank and dense_rank?

1089


What is difference between count (*) and count 1?

929


What is the purpose of optimization?

998


Explain concepts of analysis services?

963