how to add a column to the primary key?

[mokesql]

with wich sql statement can i add a column to the primary key? i have a primary kex which includes 3 colums and want another column to be added. how can i solve it. when i try alter table table name add primary key () its not possible because i get the statement that there can be only one primary key. thanx


kemo

 

[sem]

You may drop and then recreate it.