What are Magic Table?

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


Please Help Members By Posting Answers For Below Questions

what is the different types of backups available in sql server? : Sql server database administration

498


What happens when transaction log is full?

511


How to use clusters?

547


How to check parameter value in stored procedure sql server?

462


Explain filtered indexes benefits?

593






Explain data warehousing in sql server?

602


How do I open a .db file?

478


Explain forward - only cursors?

513


What are the different authentication modes in sql server?

571


Explain steps of normalization?

525


When should you use an instead of trigger?

551


What is the difference between lock, block and deadlock? : sql server database administration

563


What does REVERT do in SQL Server 2005?

558


How to create a view using data from another view?

563


How do you delete duplicate rows in sql server?

506