1. 查看某表的索引信息
exec sp_helpindex @tableName @tableName:表名
2.删除索引
--删除索引
if exists(select sysobjects.id,sysobjects.name ,sysindexes.name
from sysobjects,sysindexes where sysobjects.id = sysindexes.id
and sysobjects.type='U' and sysobjects.name='@tableName'
and sysindexes.name='index_t_activities_otherkey')
drop index t_activities.index_t_activities_otherkey
go
3.创建非聚集索引
--新增索引
if not exists(select sysobjects.id,sysobjects.name ,sysindexes.name
from sysobjects,sysindexes where sysobjects.id = sysindexes.id
and sysobjects.type='U' and sysobjects.name='t_activities'
and sysindexes.name='index_t_activities_statuskey')
CREATE nonclustered INDEX index_t_activities_statuskey ON t_activities(FStatus)
Go