Where are magic tables stored ? Is it in the same database
where it is created ?
- 4 Answers
- 12210 Views
- I also Faced
- E-Mail Answers
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 you handle datasets larger than 50 gb?
What are functions in the sql server?
How to enable tcp/ip protocol on a sql server?
Explain various On-Delete options in a DB table. Which is the default option?
Why should one not prefix user stored procedures with ‘sp_’?
Explain system scalar functions?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
How do I completely remove sql server instance?
What is explicit cursors?
Write an SQL query to obtain the 2nd highest salary.
What causes index fragmentation?
Explain different types of lock modes in sql server 2000?
Why de-normalization required?
which table keeps the locking information? : Sql server administration
Is BCNF better than 2NF & 3NF? Why?
