DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: mutation

  1. #1
    Join Date
    Nov 2000


    what is a mutation in triggers ?

  2. #2
    Join Date
    Apr 2001
    If you try to change or select the data of the same table on which the trigger is firing , then the the table is said to be mutating. this is because you are trying to alter the data in the table which is undergoing a change.

  3. #3
    Join Date
    Aug 2000
    A related issue is that you cannot access the key columns in a table with a defined primary/foreign key relationship to the mutating table. This is called a constraining table.

    Thus if your trigger in table "child" has a FK of "ID", you cannot query the related table "parent" by "ID" to update some field in that table, since the "ID" is the related field.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.