What are Magic Table?
Answer Posted / sabahuddin
Usually Inserted and Deleted Tables are called Magic Tables.Magic Tables does not contain the information about
the Columns of the DataType text,ntext or image.These are maintained by SQL Server for internal processing whenver an update,insert,Delete occur on table.However we can refer these tables in Triggers.
Whenever an updated table statement is fired SQL Server Maintains the original row before updation in a deleted table and New(Updated) row in inserted table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do I setup a local sql server database?
What is the template in sql?
what are different types of backups available in sql server? : Sql server database administration
query processing
What is filestream?
What is simple indexing method?
What is the difference between a local and a global temporary table?
What is table level trigger?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
Explain syntax for dropping triggers?
What are Spatial data types in SQL Server 2008
What is difference between equi join and inner join?
What is the difference between Normalization and De-normalization?