Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
richard bontjer
Starting Member
1 Post |
 Posted - 2005-04-08 : 05:46:41
|
| dear guru's,instead of declaring the references directly in the create statement, which gave me an error, i decided to put all my references in alter-table-statements. someting like this:alter table scrgehoor add constraint rel2_constr foreign key (rel_id) references relatie(rel_id)alter table soortafspraak add constraint srtblok_constr foreign key (srtblok_code) references soortblok(srtblok_code)alter table vwiechenantw add constraint rel3_constr foreign key (rel_id) references relatie(rel_id)etc.etc.when i refer to the relation-table for the second time, i get an errorALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'rel4_constr'. The conflict occurred in database 'DB1' Data Warehouse', table 'Relatie', column 'rel_id'.I wonder why.....Can anyone help me?greetz,richard |
|
|
|
|
|
references Relation (rel_id) error