Hi, This is a why questionk, which may be somewhat pointless, but. Why is this under alter table instead of drop index?
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 > (250) 655 - 9513 (PST Time Zone) "Inquiry is fatal to certainty." -- Will Durant --------------------------------------------------------------------- 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