>-----Original Message-----
>From: Nicole Amashta
>Sent: Thursday, February 28, 2002 8:22 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP-WIN] [N-PHP-R] Help with MySQL
>
>
>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?


If mySQL support the ISO 9075:1992 it would be:

ALTER TABLE <table name> DROP CONSTRAINT <constraint name>

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to