What are Magic Table?
Answer Posted / aastha pallav
Sometimes we need to know about the data which is being
inserted/deleted by triggers in database. With the
insertion and deletion of data, tables named “INSERTED”
and “DELETED” gets created in SQL Server which contains
modified/deleted data.
Here, “INSERTED” and “DELETED” tables are called magic
tables.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain linked server in sql?
What are locks in sql?
What do you understand by a view? What does the with check option clause for a view do?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Can we perform backup restore operation on tempdb? : sql server database administration
How sql server enhances scalability of the database system?
can any body tell me how to know the password of current user in sql server
What is difference between rownum and rowid?
What is snapshot replication?
Why should one not prefix user stored procedures with ‘sp_’?
How can you control the amount of free space in your index pages?
What is open database communication (odbc)?
Define magic tables in sql server?
How do you start single user mode in clustered installations?
If user is owning any SQL Objects, can we drop that user