查看和创建索引

/*
LiHaiJun
2009-11-05
查看和创建索引
*/
--查看指定表的索引
sp_helpindex  'taga_talkin_record0_back'

Declare
 @table varchar(100),
 @sql varchar(500)
Set @table='taga_talkin_record0_back'
Set @sql='select
 表名='''+@table+''',
 索引名称=name,
 索引类型=case when indid=1 then ''聚集索引'' else ''非聚集索引'' end
from sysindexes
where indid>=1 and indid<>255 and name not like ''_WA_Sys_%'' AND id=OBJECT_ID('''+@table+''')'
--Print @sql
Exec (@Sql)

--创建索引
Declare
 @Sql varchar(500),
 @i int
Set @i=0
While @i<10
BEGIN
 Set @Sql='CREATE  INDEX ix_taga_talkin_record'+cast(@i as varchar(10))+'_back ON taga_talkin_record'+cast(@i as varchar(10))+'_back (caller,oricallee)'
 Exec (@Sql)
 --print @Sql
 Set @i=@i+1
END