db-derby-user mailing list archives

Hi,

I would like to reference a column in another table but that column is
not designated as a primary key and unfortunately referring to it
explicitly results in this error:

ERROR XSCH5: In a base table there was a mismatch between the
requested column number 6 and the maximum number of columns 7.

So is there a way to make a column a primary key?  alter table
table_name alter column column_name primary key doesn't work.

Amir