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 do I find query history in sql server?
How to Insert multiple rows with a single insert statement?
To which devices can a backup be created and where should these devices be located? : sql server management studio
How to apply cascading referential integrity in place of triggers?
Explain what you mean by 3 tier architecture.
How to truncate the log in sql server 2012? : sql server database administration
What are a scheduled jobs?
What is store procedure?
What is the use of group by clause?
What are the different types of sql server replication? : sql server replication
what are user defined datatypes? : Sql server database administration
What is measure group, measure? : sql server analysis services, ssas
What is conditional split?
what are the disadvantages of cursors? : Sql server database administration
What is server-level principal?