Hi,
Is there any way to apply the unique constraint on the attribute of a table
through the pgAdmin?. This certainly other than applying the primary key
constraint on the attribute.
To set the foreign key relationship it is the basic requirement that the
referenced attribute should be a primary key in the referenced table.
Can I achieve FK relationship without making it a primary key?? Because I
have already defined a PK, which does not contain the referenced attribute.
If it is possible to have a unique attribute rather having PK and then
achieve the FK.
I am new to the relational world, and is in learning phase.
regds,
-anil.