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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]