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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED].; > 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 > > > -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
