adding ON UPDATE CASCADE to existing table

• winston Smith

  SSCoach

  Points: 19500

  More actions

  December 23, 2008 at 7:47 am

  #127633

  is it possible to add ON UPDATE CASCADE to existing table? I have tried a number of different combos of this and cant get it to work.

• noeld

  SSC Guru

  Points: 96590

  More actions

  December 23, 2008 at 9:55 am

  #916881

  ON UPDATE CASCADE is a property of a ForeignKey you should be able to DROP+CREATE the FK constraint.

  What error are you seeing ?

  
  * Noel