Difference SHOW INDEX, SHOW INDEXES and SHOW KEYS in MySQL

Question

What's the difference between the SHOW INDEX, the SHOW INDEXES and the SHOW KEYS command in MySQL? If any. I get the same results.

score 3 · Accepted Answer · answered Jul 21 '11 at 10:42

3

They are synonyms.

answered Jul 21 '11 at 10:42

Jacob

Yes, I read this already. But that's no explanation why there are three commands for the same query. My question is: are there really no differences? Why then three commands? – waanders Jul 21 '11 at 11:33
It's not 3 commands. It's the same command with 3 names. You did not ask for an explanation. You asked if they are the same. Some RDBMS call indexes keys, so to ease transition there is show keys and show index/indexes. – Jacob Jul 21 '11 at 11:35
Okay 3 "names". But I think it's rather confusing. And "to ease transition": but then why "INDEX" and "INDEXES"? – waanders Jul 21 '11 at 11:49

score 2 · Answer 2 · answered Jul 21 '11 at 10:42

2

As per MySQL documentations it is same :-

SHOW {INDEX | INDEXES | KEYS}
    {FROM | IN} tbl_name
    [{FROM | IN} db_name]

answered Jul 21 '11 at 10:42

Jatin Dhoot

Also it seems to be duplicate of http://stackoverflow.com/questions/1401572/what-are-differences-between-index-v-s-key-in-mysql – Jatin Dhoot Jul 21 '11 at 10:42
Not a duplicate of that question, as this question asks about a specific command and the linked question asks about indexes and keys in general. – Jacob Jul 21 '11 at 10:43
But waanders is not responsding to anyone ------ – Jatin Dhoot Jul 21 '11 at 11:19
2

The question is only 40 minutes old, a little patience ;) +1 for being 20 seconds faster :D – Jacob Jul 21 '11 at 11:19
:) ----------- Am afraid they will mark as a personal conversation – Jatin Dhoot Jul 21 '11 at 11:25

2 Answers2