Shulou(Shulou.com)05/31 Report--

Xiaobian to share with you how to delete the index sql statement to write, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let us go to understand it together!

delete the index

drop index [indexname] on mytable;

create an index

alter table tbl_name add primary key (column_list):

This statement adds a primary key, which means that the index value must be unique and cannot be null.

alter table tbl_name add unique index_name (column_list):

The value of the index created by this statement must be unique (null may occur multiple times in addition to null).

alter table tbl_name add index index_name (column_list):

Add a normal index, the index value can occur multiple times.

alter table tbl_name add fulltext index_name (column_list):

This statement specifies the index as fulltext for full-text indexing.

The above is "delete index sql statement how to write" all the contents of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.