db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Michail" <amich...@gmail.com>
Subject how do you make a column a primary key later?
Date Thu, 20 Mar 2008 18:46:21 GMT

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.


View raw message