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
- 13212 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 does it mean to normalize a database and why would you do it?
What is the process of indexing?
explain different types of constraints? : Sql server database administration
How to create database with physical files specified in ms sql server?
How to create new table with "create table" statements?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What are the 2 types of classifications of constraints in the sql server?
which table keeps the locking information? : Sql server administration
What is a collation?
What is sql azure database?
What is the parse query button used for?
How many levels of sp nesting are possible?
What happens if null values are involved in string operations?
Explain about nested stored procedure?
Define model database?
