Khargesh Rajput
What's the reason to name magic tables as magic tablesWhy we call
By Khargesh Rajput in SQL Server on Dec 30 2014
  • Anil Kumar
    Feb, 2015 26

    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

    • 2
  • Nitin Sontakke
    Jul, 2016 20

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

    • 0
  • Nitin Sontakke
    Jul, 2016 20

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

    • 0
  • Pankaj  Kumar Choudhary
    Mar, 2015 29

    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...

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS