What is Magic tables.

Question

What is Magic tables in sql server.

Vijaya Kadiyala · Answer

Hi glad to see that you are clear in basics. Thanks -- Vijaya Kadiyala

Purushottam Rathore · Answer

Thank Vijaya.

Vijaya Kadiyala · Answer

Hi The INSERTED and DELETED tables popularly known as MAGIC TABLES and update () and columns_updated() functions can be used to determine the changes being caused by the DML statements. Note that the Magic Table does not contain the information about the columns of the data-type text ntext or image. Attempting to access these columns will cause an error. Thanks -- Vijaya Kadiyala

Bechir Bejaoui · Answer

http://sqlserverpedia.com/blog/sql-server-tutorial/what-is-a-magic-table/