Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaushik
A mutating table is a table that is currently being modified
by an UPDATE, INSERT or DELETE statement, or a table that
might need to be updated by the effects of a declarative
DELETE CASCADE referential integrity action. A table is not
considered mutating for STATEMENT triggers.
The triggered table itself is a mutating table as well as
any table referencing it with the foreign key constraint.
This restriction prevents a row trigger from seeing an
inconsistent set of data.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the source code of a program?
Explain scalar functions in sql?
Why do we need unique key in a table?
What port does sql server use?
What is a sql trace file?
What are three advantages to using sql?
What is the use of function in sql?
What are the benefits of triggers?
How many indexes can be created on a table in sql?
Can a table contain multiple foreign key’s?
What is auto increment feature in sql?
How many clustered indexes can you have?
What is Collation Sensitivity ? What are the various type ?
What does where 1 1 mean in sql?
How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?
