What are Magic Table?
- 34 Answers
- 73498 Views
- 3i Infotech, Digiweb, Evalueserve, NIIT, PL, I also Faced
- E-Mail Answers
Answer Posted / manish kumar
Magic tables are created when data is inserted or updated
in the normal tables. They get deleted when the commit is
done. They are used for the auditing purposes.
They are useful in keeping track of the insertion and
updation on the database.
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What are the differences between lost updates and uncommitted dependencies?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is create command?
How to create an identity column?
Explain how you can deploy an SSRS report?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What is read committed?
How to update a field in SQL after ALTERING a row?
How to find the source of a table in sql server?
how you can deploy an ssrs report?
How to configure odbc dsn with different port numbers?
Define right outer join?
Why can there be only one clustered index and not more than one?
Is it possible to replicate data from sql server to oracle? : sql server replication
How to view existing indexes on an given table using sp_help?
