cascade update error...

• Marysa

  Ten Centuries

  Points: 1023

  More actions

  May 10, 2005 at 1:18 pm

  #186030

  ALTER TABLE CHILD_TABLE ADD CONSTRAINT RefPARENT_TABLE1

  FOREIGN KEY (parent_id)

  REFERENCES PARENT_TABLE(parent_id) ON UPDATE CASCADE

  go

  -------------------------------------------

  The above code generates the following error:

  Server: Msg 156, Level 15, State 1, Line 3

  Incorrect syntax near the keyword 'ON'

  ------------------------------------------

  any ideas why?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 10, 2005 at 1:22 pm

  #557880

  This is the statement generated by EM

  ALTER TABLE dbo.AVT_FACTMA_Impayees ADD CONSTRAINT

  FK_AVT_FACTMA_Impayees_AVT_FACTMA FOREIGN KEY

  (

  FFNOFACT_INT

  ) REFERENCES dbo.AVT_FACTMA

  (

  FFNOFACT_INT

  ) ON UPDATE CASCADE