Hi Mysql fans ;-); I have a problem understanding why MySQL is deleting a unique key instead of a primary key.
from Documentation: DROP PRIMARY KEY drops the primary index. If no such index exists, it drops the first UNIQUE index in the table. When I do it then I get this: mysql> desc uksample4; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | id | int(11) | | UNI | 0 | | | name | char(30) | YES | | NULL | | | tel | char(20) | | PRI | | | +-------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> alter table uksample4 drop primary key ; Query OK, 0 rows affected (0.24 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> desc uksample4; +-------+----------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+----------+------+-----+---------+-------+ | id | int(11) | | | 0 | | | name | char(30) | YES | | NULL | | | tel | char(20) | | PRI | | | +-------+----------+------+-----+---------+-------+ 3 rows in set (0.00 sec) It deletes the unique key (id) instead of he primary key (tel). Did I do something wrong ? MySQL 4.0.14 Best regards -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]