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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Where are magic tables stored ? Is it in the same database
where it is created ?

Question Posted / retom

Answers were Sorted based on User's Feedback



Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / digvijay kumar singh

magic table is concept of triggers. when trigger perform the
insert,delete and update action on the table. the create a
temprory table that is called the magic table. when perform
dalete action:-- all deleted row stored in to a table
thease table is called "Deleted table" such that insert
action: create "created table" these table called the magic
table.

when trigger commited the magic table automatically deleted.
it is stored in Temp database of sql server.



i hope any person gotted.

Is This Answer Correct ?    25 Yes 0 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / amitmca09

Magic tables stored in the same database

Is This Answer Correct ?    19 Yes 4 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / raja

At the time of creating triggers magic tables will be created.

Is This Answer Correct ?    9 Yes 2 No

Where are magic tables stored ? Is it in the same database where it is created ?..

Answer / digvijay kumar singh

yes, magic table stored in current databse.

Is This Answer Correct ?    8 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is similarity and difference between truncate and delete in sql?

0 Answers  

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

How to provide login information for a new odbc dsn?

0 Answers  

How to send email from database?

0 Answers  

How is sql server used?

0 Answers  

Explain active/passive and active/active cluster configurations?

0 Answers  

Why use view instead of a table?

0 Answers  

Can a table be created inside a trigger?

0 Answers  

what do you understand by change data capture?

0 Answers  

What does it mean to normalize data?

0 Answers  

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

Is it ok to shrink transaction log?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories