Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problems withe FOREIGN KEY - Constraint (msg 547)

Status
Not open for further replies.
lasombra

lasombra

Programmer
Mar 22, 2002
26
CH
I have 2 tables:

Table "Group_OU_Relation":
GrpOUID | GID | OUID
--------------------
.... | ... | ...

Table "Functions_Folders":
FFID | GrpOUID | ParentId
-------------------------
.... | ... | ...


Now I want to make a Foreign Key Constraint in table "Functions_Folders", where column "GrpOUID" references column "GrpOUID" in table "Group_OU_Relation". I get the following error, why?

ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint "Group_OU_Funct_Folders". The Conflict occured in Database xy, table "Group_OU_Relation", column "GrpOUID".
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
499
Chris Miller
Chris Miller
BTrees
  • Locked
  • Question
Incremental Load (No primary key) 2
Replies
2
Views
435
Olaf Doschke
Olaf Doschke
craigward
  • Locked
  • Question
Cross table insert duplicate key issue 1
Replies
7
Views
484
Olaf Doschke
Olaf Doschke
wbodger
  • Locked
  • Question
Constraint to modify value if not unique
Replies
3
Views
344
DaveInIowa
DaveInIowa
BxWill
  • Locked
  • Question
TSQL - Create Foreign Keys - Error: There is already an object named FK_EquipMaster" 2
Replies
8
Views
589
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top