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
How to encrypt Strored Procedure in SQL SERVER?
What is reference section?
How can you check the level of fragmentation on a table?
What is the optimization being performed in oracle and SQL Server?
Can we use pragma autonomous_transaction in trigger?
What is ms sql server triggers?
What factors you will consider calculating the storage requirement for that view?
Do you have any idea about the tcl commands?
Mention the 3 ways to get a count of the number of records in a table.
What is inner join in sql server joins?
What is the difference between rank and dense_rank?
What is sql server replication? : sql server replication
What is 1nf 2nf?
Which tools are available to manage SQL Azure databases and servers?
Does a sql server 2005 select statement require a from?