At 23:26 -0500 11/4/02, Eric Frazier wrote:
>This is a why questionk, which may be somewhat pointless, but. Why is this
>under alter table instead of drop index?
Because DROP INDEX cannot be used to drop a PRIMARY KEY.
Just like CREATE INDEX cannot be used to create a PRIMARY KEY.
>At 01:10 AM 11/5/02 -0600, Paul DuBois wrote:
>>At 12:08 +0530 11/5/02, Uma Shankari T. wrote:
>>> 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 ???
> >ALTER TABLE tbl_name DROP PRIMARY KEY;