*This message was transferred with a trial version of CommuniGate(tm) Pro*
Hi,

I have a table in my database that has one field named design_name. The 
design_name is varchar(200) unique. After I created the table the need 
appeared to have duplicates in this field. So I tried to remove the unique 
property. I used:
alter table designs modify design_name varchar(200);

I get an ok message but the unique property still stays among the field 
properties. How can I remove the unique property???


Thank you,
Cip


---------------------------------------------------------------------
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

Reply via email to