Collections:
Show All Indexes of a given Table in MySQL
How To Get a List of Indexes of a Given Table in MySQL?
✍: FYIcenter.com
If you want to see the index you have just created for an existing table, you can use the "SHOW INDEX FROM tableName" command to get a list of all indexes in a given table. The tutorial script below shows you a nice example:
mysql> SHOW INDEX FROM TIP; +------------+-------------+--------------+-------------+... | Non_unique | Key_name | Seq_in_index | Column_name |... +------------+-------------+--------------+-------------+... | 0 | PRIMARY | 1 | id |... | 1 | tip_subject | 1 | subject |... +------------+-------------+--------------+-------------+... 2 rows in set (0.03 sec)
It's interesting to see that there is a default index for the primary key column.
⇒ Drop an Existing Index in MySQL
⇐ Create an Index for a Given Table in MySQL
2018-02-14, 1289👍, 0💬
Popular Posts:
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values...