How can i see index present in mysql

Question

I have created a index on my table this way

CREATE UNIQUE INDEX  viid_in_item_topping  ON item_topping (item_id)

I am checking indexes on that table this way
```
SHOW INDEXES FROM item_topping;
```

It displayed output as

viid_in_item_topping

How can i see this particualr index ??

(Means on what field i created index)

I have tried using show viid_in_item_topping , desc viid_in_item_topping but nothing worked .

Could you please let me know how to see the index by its name ??

This question is not the same as posted in the link , how can i see the index by its name

possible duplicate of [How to see indexes for a database or table?](http://stackoverflow.com/questions/5213339/how-to-see-indexes-for-a-database-or-table) — Praveen Kumar Purushothaman, Jul 03 '15 at 12:19
`SHOW CREATE TABLE item_topping` will dump the table's current state, with indexes. — Michael Berkowski, Jul 03 '15 at 12:19
How The output of `SHOW INDEXES FROM item_topping` should display lots more information than just the name. — Michael Berkowski, Jul 03 '15 at 12:23

score 1 · Accepted Answer · answered Jul 03 '15 at 12:23

1

You can do this by either SHOW CREATE TABLE or looking in INFORMATION_SCEHMA:

SHOW CREATE TABLE item_topping;

or

SELECT * FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_NAME='item_topping'

The former is usually easier to read.

answered Jul 03 '15 at 12:23

winmutt

1 Answers1