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 a collation?

1128


What are the differences between ms sql server & oracle?

1107


How will you monitor replication latency in transactional replication? : sql server replication

1206


What are horizontal and vertical scaling?

172


How to insert and update data into a table with "insert" and "update" statements?

1038


What is the main purpose of having conversation group?

943


What is the difference between Clustered and Non-Clustered Index?

1100


When would you use the stored procedures or functions?

1050


What are subquery and its properties?

1093


Tell me something about security and sql azure?

116


How can you know if the row fetched from cursor is still valid in underlying table?

1041


How do you check sql server is up and running?

1044


How to use order by with union operators in ms sql server?

1062


What is the difference between set and select?

1152


Why do you want to join software field as you have done your BE in Electronics?

2194