Explain Magic tables in SQL Server?

devquora
devquora

Posted On: Feb 22, 2018

 

    1 Answer Written

  •  devquora
    Answered by Farheen

    In the SQL servers, magic tables are the invisible or virtual tables that can only be seen with the help of the triggers. These are those tables that allow the users to hold deleted, inserted and updated values during delete, insert, and update DML operations on the table in the server.

Related Questions

Please Login or Register to leave a response.

Related Questions

Mssql Interview Questions

What is MSSQL?

MSSQL stands for Microsoft Server SQL that is a Microsoft’s relational database management system. It is a featured d..

Mssql Interview Questions

What is SQL server agent and what are the two modes of authentication in SQL Server?

SQL Server agent The SQL Server agent plays an important part in the day to day tasks of the SQL Server Database Admini..

Mssql Interview Questions

What is SQL Profiler?

It is a tool that allows system’s administrator to monitor the events in SQL Server.It is mainly used to capture and ..