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
What are different types of raid configurations? : SQL Server Architecture
What is ms sql server triggers?
Explain table valued parameters in sql server? Why tvp used?
What is normalization 1nf 2nf 3nf?
Does transparent data encryption provide encryption when transmitting data across the network?
What is report snapshot in ssrs?
How much memory that we are using in Logshipping Concept?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What happens if we shrink log file in sql server?
What types of replication are supported in sql server?
What is global temp table?
How to backup encryption key ?
What is attribute hierarchy? : sql server analysis services, ssas
How to update muliple row in single query?
What gets stored inside msdb database?