create database MyDB
go
use MyDB
go
create table userInfo
(
userId int identity,
userName varchar(20),
userAge int
)
go
--创建索引create index(索引关键字) indexName(索引名) on userInfo(userName,userAge)
create index indexName on userInfo(userName,userAge)
--查看索引
sp_helpindex userInfo
--创建唯一性索引
create unique index indexAge on userInfo(userAge)
--删除索引
drop index indexName on userInfo
select * from userInfo
