List:General Discussion« Previous MessageNext Message »
From:Martijn Tonies Date:July 22 2004 12:58pm
Subject:Re: Foreign keys
View as plain text  
Hi,

> I have a table that with a TEXT filed as a primary key.
>
> I can't make a foreign key of this field on another table, why does this
happens?
>
> Ex:
>
> Product ---
> | ref - text, PK
> | name - text
> | ....
>
> ProductsList
> | ID int, PK
> | profref - foreign key of the table product
> | ....
>

I'm surprised you can have a TEXT column as the primary
key... :-)

Doesn't this strike you at least as "weird"?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

Thread
Foreign keysRuiSMonteiro22 Jul
  • Re: Foreign keysMartijn Tonies22 Jul