duplicate Foreign KEy Constraint

• bhakti-sonu

  Mr or Mrs. 500

  Points: 556

  More actions

  February 12, 2009 at 4:32 am

  #97110

  I created one table "Employee" set one foreign key named FK_DepartmentID in "Department" Table.

  then i removed it by mistake..

  after some days i realise that there is no foreign key relation in both tables so I again want to add with same name but now it is giving an error that it already having FK_DepartmentID where as the key is not visible in table relations.

  Is the key created is still there is database? if yes then where it goes?

  if i set option "Check Existing Data on Creation or ReEnabling" =No

  then it don't give any error.

  what this option do?

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  February 12, 2009 at 5:44 am

  #942747

  check the sys.foreign_keys table.

  "Keep Trying"