Re: [N-PHP-R] Help with MySQL

OK, none is right here. I had already tried the alter and change and modify before I even attempted to ask on this list. say i have this table: create table ftp(id int not null auto_increment primary key, accountnbr varchar(30), login varchar(30) unique, password varchar(20), createdate datetime); So, how can I drop that unique constraint? The constaint isn't named? Only thing I can think of is, IF that unique thing is actually an index, I can drop the index ... but problem is, I can't remember what the name of the index was. I think it was ix_login, or idx_login, or index_login. Something like that. I am about to try that. Wish me luck. Nix0r www.aeontrek.com "Nicole Amashta" <430ntr3k@bellsouth.net> wrote in message news:20020228192246.91806.qmail@pb1.pair.com... > I know this is not MySQL, so that's why I put the [N-PHP-R] in the subject > (means Non-PHP-Related) > > But, my problem is this. > > I have a table in MySQL. One of the fields (not the primary key), has a > unique constraint on it. I need to remove this unique constraint, but I > can't figure out how. I dn't see this in the MySQL docs. > > Does anyone know how to remove uniquness from a field? > > > Thanks, > > -- > Nicole Amashta > Web Applications Developer > www.aeontrek.com > > >