Where are magic tables stored ? Is it in the same database
where it is created ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / raja
At the time of creating triggers magic tables will be created.
Is This Answer Correct ? | 9 Yes | 2 No |
Answer / digvijay kumar singh
yes, magic table stored in current databse.
Is This Answer Correct ? | 8 Yes | 2 No |
What is the Main Difference between ACCESS and SQL SERVER?
What is filestream?
What are number line correlation administrators will use while working with a subquery?
Explain trigger and its types?
what is the difference between group and having give an example with query and sample output
what is a deadlock? : Sql server database administration
What stored by the model? : sql server database administration
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
Whether the updations made to the views reflect the original records in the table
What is meant by datasource?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to grant a permission in ms sql server using "grant execute" statements?