SqlServer关于索引创建和删除

暂做个记录，后面有空再补充。

–普通索引: create index[index_name] on table(column_name)

–唯一索引：create index[index_name] on table(column_name)

–聚集索引：create clustered index[index_name] on table(column_name)

–非聚集索引：create nonclustered index[index_name] on table(column_name)

–复合索引：create index[index_name] on table(column_name1,column_name2)

–复合聚集索引：create clustered index[index_name] on table(column_name1,column_name2)

–复核非聚集索引：create nonclustered index[index_name] on table(column_name1,column_name2)

–删除索引：drop index[index_name] on table