At 23:26 -0500 11/4/02, Eric Frazier wrote:
Hi,
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.
Thanks,
Eric
At 01:10 AM 11/5/02 -0600, Paul DuBois wrote:
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;
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php