Jay
Are you sure? DESCRIBE tells me the table has an index, but not whether the index is enabled or not:
mysql> create table t1 (x int primary key); Query OK, 0 rows affected (0.01 sec)
mysql> create table t2 (x int primary key); Query OK, 0 rows affected (0.01 sec)
mysql> alter table t1 disable keys; Query OK, 0 rows affected (0.00 sec)
mysql> describe t1; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | x | int(11) | NO | PRI | | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec)
mysql> describe t2; +-------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+---------+------+-----+---------+-------+ | x | int(11) | NO | PRI | | | +-------+---------+------+-----+---------+-------+ 1 row in set (0.00 sec)
Am I missing something?
thanks, Jacek
Jay Blanchard wrote:
[snip] How can I find out if keys are enabled/disabled for a given table?
Suppose I do: create table t1 (x int primary key); create table t2 (x int primary key); alter table t1 disable keys;
How can I now find out that t1 has keys disabled, and t2 enabled? [/snip]
DESCRIBE t1 or DESCRIBE t2
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]