Drop foreign Key constraint

  • You cannot drop a foriegn key with DRI(declarative referential integrity) constrant because the CASCADE UPDATE, CASCADE DELETE, CASCADE SET NULL and CASCADE SET DEFAULT if all are enabled must be dropped before you can drop the foriegn key. 

    DRI means if A references B B must exist you are trying to drop B which will lead to data integrity issues and the Relational model is set up to stop such operations.

     Hope this helps.

     

    Kind regards,
    Gift Peddie

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply