Multiple columns having same foreign key

[Jayavardhan geepi]

Hi..

In a table I have 2 columns which must refer to same column of another table.

while Executing alter table query for 2nd column it says such a constraint already exists.

Can some one help.. Is this possible?

[Martin Vajsar]

Yes, it should be possible, like this:
create table a(x number primary key); create table b(y number, z number); alter table b add constraint b_y foreign key(y) references a; alter table b add constraint b_z foreign key(z) references a; Post your script and error messages if you cannot resolve it.