Foreign keys Please help : LUSENET : SQL Server Database Administration : One Thread


I have two tables

Table A has columns name, type, desciption and Table B has columns id, number, description.

I want to establish foreign key relation between both the tables. But note that there is no unique index or primary key relation for the column 'description' in both the tables. How do I establish this relationship. I am using SQL server 7.0 and when I try to do this I am getting error message.

Thanks Jay

-- Anonymous, July 27, 2000



As far as I know, Foreign key has to defined on an existing primary key and primary key, by definition is UNIQUE So to answer your question, NO it cant be done !

Thanks, Vic

-- Anonymous, July 27, 2000

Moderation questions? read the FAQ