{"id":6820,"date":"2018-08-12T08:32:38","date_gmt":"2018-08-12T15:32:38","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6820"},"modified":"2023-10-23T05:58:10","modified_gmt":"2023-10-23T12:58:10","slug":"mysql-drop-index","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/","title":{"rendered":"MySQL DROP INDEX"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the MySQL <code>DROP INDEX<\/code> statement to remove existing indexes of a table.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to MySQL DROP INDEX statement<\/h2>\n\n\n\n<p>To delete an existing index from a table, you use the <code>DROP INDEX<\/code> statement as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DROP<\/span> <span class=\"hljs-keyword\">INDEX<\/span> index_name \n<span class=\"hljs-keyword\">ON<\/span> table_name\n&#91;algorithm_option | lock_option];<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, specify the name of the index which you want to remove after the <code>DROP INDEX<\/code> keywords.<\/li>\n\n\n\n<li>Second, specify the name of the table to which the index belongs.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Algorithm<\/h3>\n\n\n\n<p>The <code>algorithm_option<\/code> allows you to specify a specific algorithm used for the index removal. <\/p>\n\n\n\n<p>The following shows the syntax of the <code>algorithm_option<\/code> clause:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">ALGORITHM &#91;=] {DEFAULT|INPLACE|COPY}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>For the index removal, the following algorithms&nbsp;are supported:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>COPY<\/code>: MySQL copies data from the original table to a new table row by row. After completing the copy, the DROP INDEX executes on the newly created table. Please note that during the copy process, you&#8217;re not allowed to perform any concurrent data manipulation statements such as <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-insert\/\">INSERT<\/a><\/code> and <code><a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-update\/\">UPDATE<\/a><\/code>.<\/li>\n\n\n\n<li><code>INPLACE<\/code>: The INPLACE algorithm involves rebuilding the table directly in its existing location without creating a new copy of the table. During both the preparation and execution phases of the index removal process, MySQL places an exclusive metadata lock on the table. This allows concurrent data manipulation statements to be executed alongside the index removal process.<\/li>\n<\/ul>\n\n\n\n<p>Note that the <code>ALGORITHM<\/code> clause is optional. If you skip it, MySQL uses <code>INPLACE<\/code>. In case the <code>INPLACE<\/code> is not supported, MySQL uses <code>COPY<\/code>.<\/p>\n\n\n\n<p>Using <code>DEFAULT<\/code> has the same effect as omitting the <code>ALGORITHM<\/code> clause.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Lock<\/h3>\n\n\n\n<p>The <code>lock_option<\/code> controls the level of concurrent reads and writes on the table while the index is being removed.<\/p>\n\n\n\n<p>The following shows the syntax of the <code>lock_option<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">LOCK<\/span> &#91;=] {<span class=\"hljs-keyword\">DEFAULT<\/span>|<span class=\"hljs-keyword\">NONE<\/span>|<span class=\"hljs-keyword\">SHARED<\/span>|EXCLUSIVE}<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The following locking modes are supported:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u00a0<code>DEFAULT<\/code>: This allows you to have the maximum level of concurrency for a given algorithm. First, it allows concurrent reads and writes if supported. If not, allow concurrent reads if supported. If not, enforce exclusive access.<\/li>\n\n\n\n<li>\u00a0<code>NONE<\/code>: If the <code>NONE<\/code> is supported, you can have concurrent reads and writes. Otherwise, MySQL issues an error.<\/li>\n\n\n\n<li>\u00a0<code>SHARED<\/code>: If the <code>SHARED<\/code> is supported, you can have concurrent reads but not writes. MySQL issues an error if the concurrent reads are not supported.<\/li>\n\n\n\n<li>\u00a0<code>EXCLUSIVE<\/code>: This enforces exclusive access.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL DROP INDEX statement examples<\/h2>\n\n\n\n<p>Let&#8217;s <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-create-table\/\">create a new table<\/a> for the demonstration:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> leads(\n    lead_id <span class=\"hljs-built_in\">INT<\/span> AUTO_INCREMENT,\n    first_name <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">100<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n    last_name <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">100<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n    email <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">255<\/span>) <span class=\"hljs-keyword\">NOT<\/span> <span class=\"hljs-literal\">NULL<\/span>,\n    information_source <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">255<\/span>),\n    <span class=\"hljs-keyword\">INDEX<\/span> <span class=\"hljs-keyword\">name<\/span>(first_name,last_name),\n    <span class=\"hljs-keyword\">UNIQUE<\/span> email(email),\n    PRIMARY <span class=\"hljs-keyword\">KEY<\/span>(lead_id)\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The following statement removes the <code>name<\/code> index from the <code>leads<\/code> table:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DROP<\/span> <span class=\"hljs-keyword\">INDEX<\/span> <span class=\"hljs-keyword\">name<\/span> <span class=\"hljs-keyword\">ON<\/span> leads;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The following statement drops the <code>email<\/code> index from the <code>leads<\/code> table with a specific algorithm and lock:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DROP<\/span> <span class=\"hljs-keyword\">INDEX<\/span> email <span class=\"hljs-keyword\">ON<\/span> leads\nALGORITHM = INPLACE \n<span class=\"hljs-keyword\">LOCK<\/span> = <span class=\"hljs-keyword\">DEFAULT<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">MySQL DROP PRIMARY KEY index<\/h2>\n\n\n\n<p>To drop the <a href=\"https:\/\/www.mysqltutorial.org\/mysql-basics\/mysql-primary-key\/\">primary key<\/a> whose index name is <code>PRIMARY<\/code>, you use the following statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DROP<\/span> <span class=\"hljs-keyword\">INDEX<\/span> <span class=\"hljs-string\">`PRIMARY`<\/span> <span class=\"hljs-keyword\">ON<\/span> table_name;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Notice that the <code>PRIMARY<\/code> is a reversed word in MySQL. However, the index name is PRIMARY. Therefore, you need to place the PRIMARY inside the quotes to specify the primary index.<\/p>\n\n\n\n<p>The following statement creates a new table named <code>t<\/code> with a primary key:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">TABLE<\/span> t(\n    pk <span class=\"hljs-built_in\">INT<\/span> PRIMARY <span class=\"hljs-keyword\">KEY<\/span>,\n    c <span class=\"hljs-built_in\">VARCHAR<\/span>(<span class=\"hljs-number\">10<\/span>)\n);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>To drop the primary key index, you use the following statement:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-9\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">DROP<\/span> <span class=\"hljs-keyword\">INDEX<\/span> <span class=\"hljs-string\">`PRIMARY`<\/span> <span class=\"hljs-keyword\">ON<\/span> t;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-9\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the <code>DROP INDEX<\/code> statement to remove an existing index.<\/li>\n\n\n\n<li>Use the <code>DROP INDEX `PRIMARY`<\/code> to remove the primary index.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"6820\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/\"\n\t\t\t\tdata-post-title=\"MySQL DROP INDEX\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"6820\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/\"\n\t\t\t\tdata-post-title=\"MySQL DROP INDEX\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This tutorial shows you how to use the MySQL DROP INDEX statement to remove existing indexes of a table.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6818,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6820","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL DROP INDEX Statetement<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL DROP INDEX Statetement\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-23T12:58:10+00:00\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/mysql-drop-index\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/mysql-drop-index\\\/\",\"name\":\"MySQL DROP INDEX Statetement\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"datePublished\":\"2018-08-12T15:32:38+00:00\",\"dateModified\":\"2023-10-23T12:58:10+00:00\",\"description\":\"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/mysql-drop-index\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/mysql-drop-index\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/mysql-drop-index\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Index\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-index\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL DROP INDEX\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL DROP INDEX Statetement","description":"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/","og_locale":"en_US","og_type":"article","og_title":"MySQL DROP INDEX Statetement","og_description":"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-10-23T12:58:10+00:00","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/","url":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/","name":"MySQL DROP INDEX Statetement","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"datePublished":"2018-08-12T15:32:38+00:00","dateModified":"2023-10-23T12:58:10+00:00","description":"In this tutorial, you will learn how to use the MySQL DROP INDEX statement to remove existing indexes of a table.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-index\/mysql-drop-index\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Index","item":"https:\/\/www.mysqltutorial.org\/mysql-index\/"},{"@type":"ListItem","position":3,"name":"MySQL DROP INDEX"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6820","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=6820"}],"version-history":[{"count":4,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6820\/revisions"}],"predecessor-version":[{"id":11600,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6820\/revisions\/11600"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6818"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=6820"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}