Where are magic tables stored ? Is it in the same database
where it is created ?
Answer Posted / 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 |
Post New Answer View All Answers
What are the new scripting capabilities of ssms? : sql server management studio
You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?
What is identity?
Explain having clause?
What is report subscription?
Does any body please help me what question's have asked for SSRS in the interview?
How to connect ms access to sql servers through odbc?
What is sleeping status in sql server?
Tell me what do we need queues in sql service broker?
Do you know what is user defined datatypes and when you should go for them?
Why we use functions in sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are the different Topologies in which Replication can be configured?
Define inner join? Explain with an example?
How can you control the amount of free space in your index pages?