RE: [PHP-WIN] [N-PHP-R] Help with MySQL
| From: | HKG) | Date: | Thu, 28 Feb 2002 19:34:27 +0000 |
| Subject: | RE: [PHP-WIN] [N-PHP-R] Help with MySQL | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-12344@lists.php.net to get a copy of this message | ||
>-----Original Message-----
>From: Nicole Amashta
>Sent: Thursday, February 28, 2002 8:22 PM
>To: php-windows@lists.php.net
>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>