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

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

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

0 Answers  


How each E-R model constructs can be mapped to the relational model?

0 Answers   HCL,


How do you create an execution plan?

0 Answers  


What do I need to start working with sql studio? : sql server management studio

0 Answers  


What are the four main query statements?

7 Answers   Wipro,


Explain how to integrate the ssrs reports in application?

0 Answers  


What is the difference between indexing and hashing?

0 Answers  


Explain the difference between delete,drop and truncate in SQL Server?

0 Answers   HCL,


Describe in brief sql server monitoring ways.

0 Answers  


What are cursors stored procedures and triggers?

0 Answers  


What is implicit cursors?

0 Answers  


Explain how dts is used to extract, transform and consolidate data?

0 Answers  


Categories