Bug #10370 impossible to find if keys enabled/disabled
Submitted: 4 May 2005 21:12 Modified: 5 May 2005 22:08
Reporter: Jacek Becla Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:any OS:Any (any)
Assigned to: CPU Architecture:Any

[4 May 2005 21:12] Jacek Becla
Description:
As far as I can tell there is no way to find out whether keys are enabled/disabled for a given table. Example: 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?

How to repeat:
n/a
[5 May 2005 22:08] Geert Vanderkelen
We're sorry, but the bug system is not the appropriate forum for 
asking help on using MySQL products. Your problem is not the result 
of a bug.

Support on using our products is available both free in our forums
at http://forums.mysql.com and for a reasonable fee direct from our
skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

Tip: SHOW INDEX

Regards,

Geert