Magic Tables in SQL
Can anyone tell me when Magic tables are created?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Oct 12, 2011, 12:30 AM
the magic tables are deleted and inserted.while we are inserting or deleting a rows into a object the
magic tables gets created and after the commit transactionthe tables are removed.so it is called magic tables.its temp tables ,they just hold recently inserted and deleted data.
Thank You.
Pravin.