4
Reply

What's the reason to name magic tables as magic tablesWhy we call

Khargesh Rajput

Khargesh Rajput

Dec 30, 2014
1.4k
0

    The tables "INSERTED" and "DELETED" are called magic tables of the SQL Server. We can not see these tables in the data base. But we can access these tables from the "TRIGGER" They are called magic tables because like a magic you can't see it but they are actually there to be used inside triggers

    Anil Kumar
    February 26, 2015
    2

    Because these are not visible in information schema like, sys.tables and are visible only within the scope of a trigger.

    Nitin Sontakke
    July 20, 2016
    0

    Because these are not visible in information schema like, sys.tables and are visible only within the scope of a trigger.

    Nitin Sontakke
    July 20, 2016
    0

    In sql we hav two magic tables Inserted, deleted when we perform any operation of DML like insert, delete,update then these tables activate automatically .... we can not see these table but can use through trigger...