Collections:
Drop an Existing Index in MySQL
How To Drop an Existing Index in MySQL?
✍: FYIcenter.com
If you don't need an existing index any more, you should delete it with the "DROP INDEX indexName ON tableName" statement. Here is an example SQL script:
mysql> DROP INDEX tip_subject ON tip; Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> SHOW INDEX FROM TIP; +------------+-------------+--------------+-------------+... | Non_unique | Key_name | Seq_in_index | Column_name |... +------------+-------------+--------------+-------------+... | 0 | PRIMARY | 1 | id |... +------------+-------------+--------------+-------------+... 1 row in set (0.00 sec)
⇐ Show All Indexes of a given Table in MySQL
2018-02-14, 1524🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...