CODEWITHSUNDEEP
mysqldatabase
waanders
waanders

Reputation: 9083

Difference SHOW INDEX, SHOW INDEXES and SHOW KEYS in MySQL

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.

Upvotes: 2

Views: 2238

Answers (2)

Jacob
Jacob

Reputation: 43299

MySQL Doc

They are synonyms.

Upvotes: 3

Jatin Dhoot
Jatin Dhoot

Reputation: 4364

As per MySQL documentations it is same :-

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

http://dev.mysql.com/doc/refman/4.1/en/show-index.html

Upvotes: 2

Related Questions