Query to retrieve index details for a particular column in all tables

1 vote

2 answers

4662 views

mysql index mysql-5.6 information-schema

                          There is a column created_at in most of tables.

I would like to get the details if that field exists in the table and it is not indexed.

Is there any thing can be done with the information_schema to get this checked?

I'm using MySQL 5.6

Asked by Black Panther (11 rep)

Jun 15, 2016, 01:26 PM
Last activity: Jan 20, 2023, 12:02 AM

Query to retrieve index details for a particular column in all tables

Related Questions