Because a primary key is a table property and the index of the key is a property of the primary key. If you want ot drop a primary key you alter the table
> -----Original Message----- > From: Eric Frazier [mailto:ef@;kwinternet.com] > Sent: Tuesday, 5 November 2002 15:26 > To: Paul DuBois > Cc: Uma Shankari T.; [EMAIL PROTECTED] > Subject: Re: Removal of Primary Key in Mysql > > > 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 > > --------------------------------------------------------------------- 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