Re: Removal of Primary Key in Mysql

[Paul DuBois]

At 12:08 +0530 11/5/02, Uma Shankari T. wrote:
>Hello,
>
>   I have set one of my field in the mysql table as primary key..no i want
>to remove that primary key setting in mysql..Can anyone please tell me how
>to do that ???
>
>Regards,
>Uma

ALTER TABLE tbl_name DROP PRIMARY KEY;