Interested to Buy Any Domain ? << Click Here >> for more details...
Where are magic tables stored ? Is it in the same database
where it is created ?
- 4 Answers
- 13044 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
what is sql server? : Sql server database administration
How to filter out duplications in the returning rows in ms sql server?
What the class forname () does?
Tell me what is de-normalization and what are some of the examples of it?
Can you explain the disadvantages/limitation of the cursor?
What is the command used to recompile the stored procedure at run time?
Explain full-text indexing?
What are the advantages of using cte?
Explain differences between web edition and business edition?
What is nonclustered index on computed columns?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
in the physical file layout, where should the transaction log be stored in relation to the data file?
List some major differences between triggers and stored procedures?
What is 3nf normalization?
How to delete database objects with "drop" statements in ms sql server?
