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
- 12995 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
Explain Capacity planning to create a database? and how to monitor it?
How to apply filtering criteria at group level with the having clause in ms sql server?
Tell me something about security and sql azure?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is sub-query in sql server? Explain its properties.
What is buffer cash and log cache in sql server?
Explain about Joins?
what is an index? : Sql server database administration
How to create a view on an existing table in ms sql server?
Can we write trigger for view?
Explain how you can deploy an SSRS report?
What is row_number () and partition by in sql server?
What is the use of partition by in sql server?
How to write character string constants or literals in ms sql server?
How to set database to be single_user in ms sql server?
