I think it's like this... alter table hrcontract drop index login
... assuming the name of the key is "login". You can have key names (which is what a unique constraint is) and column names of the same name. If you do a ... show index from hrcontract ... it'll show you all of the "key_name" values paired with the column names that are with that table that you can drop. > -----Original Message----- > From: dan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, January 09, 2002 10:13 AM > To: [EMAIL PROTECTED] > Subject: alter table, remove unique? > > > Hi, > > I'd like to alter a field and change it from being Unique > using the alter > table command but can't seem to get the syntax correct? Can > someone give > me an example? IE: > > alter table hrcontact modify login varchar(70) not null default'' _NOT > UNIQUE'; > > thanks, > > Dan > > > > --------------------------------------------------------------------- > 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
