What are Magic Table?

Answer Posted / anand k

the magic tables are deleted and inserted.
while we are inserting or deleting a rows into a object the
magic tables were created and after the commit transaction
the tables are removed.so it is called magic tables

Is This Answer Correct ?    106 Yes 21 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define left outer join in sql server joins?

569


Explain user defined functions?

625


Explain the difference between primary keys and foreign keys?

519


Benefits of Stored Procedures?

575


how many clustered indexes can be created on a table? : Sql server database administration

571






How ssrs maintain security?

585


You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

538


How to Update from select query in sql server?

554


How to convert character strings into numeric values?

584


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1476


How to include date and time values in sql statements?

636


What is difference between clustered and non clustered index?

538


Why is sql server log file full?

543


What is difference between sql and sql server?

550


What are the differences between union, intersect, and minus operators?

584