Sql Server 2000生成索引信息及自动创建脚本解决方案

create proc p_helpindex@tbname sysname ='' ,@CLUSTERED int = '1'as--生成索引信息及索引创建脚本--author : happyflystone--         Http://blog.csdn.net/happyflystone[email protected] 表名，空返回空[email protected]   是否显示聚集索引,1显示聚集索引,2不显示聚集索引--调用：p_helpindex 'dbo.customers','1'--转载请注明出处if @tbname is null or @tbname = ''    return -1declare @t table(    table_name nvarchar(100),    schema_name nvarchar(100),    fill_factor int,    is_padded int,    ix_name nvarchar(100),    type int,    keyno int,.......................--testcreate table tb_test(id int,dept varchar(20))goCREATE UNIQUE CLUSTERED INDEX idx_6 ON tb_test(id) ON [PRIMARY] CREATE NONCLUSTERED INDEX idx_1 ON tb_test(id) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_2 ON tb_test(id) WITH PAD_INDEX,FILLFACTOR =90 ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_3 ON tb_test(id) WITH FILLFACTOR =90 ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_4 ON tb_test(id,dept) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_5 ON tb_test(dept,id) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_7 ON tb_test(id,dept desc ) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_8 ON tb_test(id desc ,dept) ON [PRIMARY]goexec p_helpindex 'tb_test'drop proc p_helpindexdrop table tb_test/*col-----------------------------------------------------CREATE UNIQUE CLUSTERED INDEX idx_6 ON tb_test(id) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_1 ON tb_test(id) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_2 ON tb_test(id) WITH FILLFACTOR =90 ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_3 ON tb_test(id) WITH FILLFACTOR =90 ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_4 ON tb_test(id,dept) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_5 ON tb_test(dept,id) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_7 ON tb_test(id,dept desc ) ON [PRIMARY]CREATE NONCLUSTERED INDEX idx_8 ON tb_test(id desc ,dept) ON [PRIMARY]*/