1.索引分类
- 主键索引
- 唯一索引unique
- 聚集索引clustered
- 非聚集索引nonclustered
2.建立与删除索引
create index
drop index
3.聚集索引
alter table course2
add constraint pk_course2_cno primary key clustered(cno)
4.唯一索引
create unique index idxcoursename
on course2(name)
5.删除索引
drop index idxcoursename on course2
drop index course2.idxcoursename