Re: Problems with the unique properties...

2001-08-17 Thread Werner Stuerenburg
UNIQUE is an index property. You need to remove the index with the drop command. Ciprian A. schrieb am Freitag, 17. August 2001, 15:01:51: > *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

Re: Problems with the unique properties...

2001-08-17 Thread Gerald Clark
Ciprian A. wrote: > *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 fiel

Problems with the unique properties...

2001-08-17 Thread Ciprian A.
*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 uniqu