Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Indexed or Unindexed Table

3 Posts 3 Posters 16 Views 1 Watching

W Offline
W Offline
Widgets

wrote on last edited by

#1

How do I know that a certain table has an index or has been indexed? What is the Index Name? Please Help thanks..
G C 2 Replies Last reply

0
W Widgets

How do I know that a certain table has an index or has been indexed? What is the Index Name? Please Help thanks..
G Offline
G Offline
Graham Breach

wrote on last edited by

#2

You can use SHOW INDEXES FROM table_name
1 Reply Last reply

0
W Widgets

How do I know that a certain table has an index or has been indexed? What is the Index Name? Please Help thanks..
C Offline
C Offline
chevu

wrote on last edited by

#3

If you are using PhpMyAdmin, it will show all primary and secondary index related with table.
1 Reply Last reply

0

Log in to reply