Technical Discussion :: SQL
Home > Technical Interview Q&A > SQL > Discussion
16 / 108
What is Mutation of Tables?
Answer:
Mutation happens in case of triggers. A 'Mutating table' is a table which is being updated by Insert , update or delete triggers.It can also be a table which is being updated when delete cascade is run. Mutation occurs when a trigger is trying to update a row which it is using currently
Asked In ::
Monisha
10 Jul, 2019 11:28 AM
Mutation happens in case of triggers. A 'Mutating table' is a table which is being updated by Insert , update or delete triggers.It can also be a table which is being updated when delete cascade is run. Mutation occurs when a trigger is trying to update a row which it is using currently