mysql>
mysql> CREATE TABLE Orders
-> (
-> OrderID SMALLINT UNSIGNED NOT NULL PRIMARY KEY,
-> ModelID SMALLINT UNSIGNED NOT NULL,
-> UNIQUE unique_1 (OrderID, ModelID)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql>
mysql> ALTER TABLE Orders
-> DROP INDEX unique_1;
Query OK, 0 rows affected (0.02 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql>
DROP INDEX ON
mysql>
mysql> drop table orders;
Query OK, 0 rows affected (0.00 sec)