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
- 13369 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
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
Why would you call update statistics?
What is the process of normalising?
What are the new scripting capabilities of ssms? : sql server management studio
What happens on checkpoint?
What will be query used to get the list of triggers in a database?
Explain sql server service broker?
What is a synonym for manipulation?
How to use transact-sql statements to access the database engine?
What is difference between inner join and join?
Can we write trigger for view?
What is awe?
What are system databases in ms sql server?
Explain for xml explicit mode?
How can we get count of the number of records in a table?
