一、创建索引:
语法: CREATE [索引类型] INDEX 索引名称 ON 表名(列名)
1.聚集索引 CREATE CLUSTERED INDEX INDEX_NAME ON TABLE_NAME (CLOUMN_NAME);
2.非聚集索引 CREATE NONCLUSTERED INDEX INDEX_NAME on TABLE_NAME (CLOUMN_NAME);
3.唯一索引 CREATE UNIQUE INDEX INDEX_NAME on TABLE_NAME(CLOUMN_NAME)
二、删除索引:
DROP INDEX index_name ON talbe_name
ALTER TABLE table_name DROP INDEX index_name
ALTER TABLE table_name DROP PRIMARY KEY