[SOLVED] changing properties to field in mysql table

[birowakskip]

I really need to change the primary key to one table in my database. Is there a way I can do so without deleting the whole table.

[Illusion]

ALTER TABLE tablename DROP PRIMARY KEY, ADD PRIMARY KEY(newcolumn1,newcolumn2,....);

[birowakskip]

 

Thanks alot