Foreign Key on a table with no primary key

[mca47378]

Hi,
Can we create a foreign key on a table where there is no primary key defined, although the referened table has primary key defined?

Thank You,
Mithu

[ck9663]

Hi,
Can we create a foreign key on a table where there is no primary key defined, although the referened table has primary key defined?

Thank You,
Mithu

Did you try it?

-- CK

[mca47378]

Did you try it?

-- CK

Hi,
Yes, I was trying to do it which intern giving me error. But I am not sure that that is because of this. I checked everything and seems that everything working good and are in place, so I may have doubt on this. Thats why I wanted to make it clear with you all.

Thank You,
Mithu

[amitpatel66]

Foreign key can be created on a table that has a primary key or unique key column

[mca47378]

Hi,
Thanks for response.

But my question is just opposite to what you have answered. Can we create a foreign key on a table which dont have a primary key?

[ck9663]

What error are you getting? I just created one and it worked.

Here's the guide.


-- CK