自动建立表全部字段索引的存储过程（SQL Server版本）

此存储过程可以自动将指定表的全部字段自动建立索引

 

create proc createallindex
@table varchar(200)
as
begin
        declare cur_webpages cursor
        for select name from syscolumns where id =(select id from sysobjects where name=@table)
       
        declare @name sysname
        declare @indexname varchar(300)
        declare @i int
        set @i=0
        open cur_webpages
        fetch next from cur_webpages into @name
        while (@@fetch_status=0)
        begin
                set @i=@i+1
                set @indexname=@table+convert(char,@i)
                exec ('create index '+@indexname+' on '+ @table+'('+@name+')')
                fetch next from cur_webpages into @name
        end
        close cur_webpages
        deallocate cur_webpages
end

GO

 

用法：

exec createallindex 'Employee'