SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER proc [SYS_ADDIndex]
as
--插入索引
declare @table1 table(tname varchar(50),cname varchar(50),indexname varchar(100))
insert into @table1
select 'VFU1','VAO01','IX_VFU1_VAO01'
union
select 'FHN1','FHN05','IX_FHN1_FHN05'
union
select 'FHN1','FHN06','IX_FHN1_FHN06'
union
select 'FHN1','VAA01','IX_FHN1_VAA01'
union
select 'VBV1','VAA07','IX_VBV1_VAA07'
union
select 'VBV1','VAF01','IX_VBV1_VAF01'
union
select 'BDU1','BBX01','IX_BDU1_BBX01'
union
select 'BDU1','BBY01','IX_BDU1_BBY01'
union
select 'BDU1','ACF01','IX_BDU1_ACF01'
union
select 'VBM1','VAA01','IX_VBM1_VAA01'
union
select 'VBM1','VBM03','IX_VBM1_VBM03'
union
select 'VBM1','VAA07','IX_VBM1_VAA07'
union
select 'VBM2','VAA01','IX_VBM2_VAA01'
union
select 'VBM2','ACF01','IX_VBM2_ACF01'
union
select 'VBM2','VAA07','IX_VBM2_VAA07'
union
select 'SCA1','VAA01','IX_SCA1_VAA01'
union
select 'SCA1','SCA06','IX_SCA1_SCA06'
union
select 'SCA1','SCA26','IX_SCA1_SCA26'
union
select 'SYS_HostUpdate','HostId','IX_SYS_HostUpdate_HostId' 
union
select 'LAO1','BarNo','IX_LAO1_BarNo' 
union
select 'VAA1','IAK05','IX_VAA1_IAK05'
union
select 'VAF1','VAF04','IX_VAF1_VAF04' 
union
select 'VAF2','VAF04','IX_VAF2_VAF04' 
union
select 'VAF1','VAF10','IX_VAF1_VAF10' 
union
select 'VAF2','VAF10','IX_VAF2_VAF10' 
union
select 'VAF1','VAF11','IX_VAF1_VAF11' 
union
select 'VAF2','VAF11','IX_VAF2_VAF11' 
union
select 'VAF1','VAF51','IX_VAF1_VAF51' 
union
select 'VAF2','VAF51','IX_VAF2_VAF51' 
union
select 'VAF1','VAF07','IX_VAF1_VAF07' 
union
select 'VAF2','VAF07','IX_VAF2_VAF07' 
union
select 'PED1','PED14','IX_PED1_PED14' 
union 
select 'VAA1','VAA05','IX_VAA1_VAA05' 
union 
select 'VAA1','ABBRW','IX_VAA1_ABBRW' 
union
select 'VAM1','VAA07','PK_VAM1_VAA07' 
UNION
select 'VAV1','VAV01','PK_VAV1_VAV01' 
UNION
select 'VAV1','VAT01','PK_VAV1_VAT01' 
UNION
select 'VAX1','VAX01','PK_VAX1_VAX01' 
UNION
select 'VAX1','VAT01','PK_VAX1_VAT01' 
UNION
select 'VAT1','VAT01','PK_VAT1_VAT01' 
UNION
select 'VAT1','VAA01','PK_VAT1_VAA01' 
UNION
select 'VAT1','VAA07','PK_VAT1_VAA07' 
UNION
select 'VAT1','VAF01','PK_VAT1_VAF01' 
UNION
select 'VAT1','VAQ01','PK_VAT1_VAQ01' 
UNION
select 'VAT1','VAT04','PK_VAT1_VAT04' 
UNION
select 'PAQ1','PAQ07','IX_PAQ1_PAQ07' 
UNION
select 'VAJ2','BDN01','IX_VAJ2_BDN01' 
UNION
select 'VAJ1','BDN01','IX_VAJ1_BDN01' 
UNION
select 'IAM1','IAA01','IX_IAM1_IAA01' 
UNION
select 'IAM1','BBY01','IX_IAM1_BBY01'  
UNION
select 'IAM1','IAH01','IX_IAM1_IAH01'  
UNION
select 'LTI1','LAB01','IX_LTI1_LAB01' 
UNION
select 'LTI1','LAC01','IX_LTI1_LAC01' 
UNION
select 'LTI1','VAA01','IX_LTI1_VAA01' 
UNION
select 'LTI1','VAA07','IX_LTI1_VAA07' 
UNION
select 'LTI1','LTI06','IX_LTI1_LTI06' 
UNION
select 'VAE1','VAE44','IX_VAE1_VAE44' 
UNION
select 'VAC1','VAC34','IX_VAC1_VAC34' 
UNION
select 'PAJ1','PAJ01','IX_PAJ1_PAJ01' 
UNION
select 'PAJ1','PAA01','IX_PAJ1_PAA01' 
UNION
select 'PAJ1','PAH02','IX_PAJ1_PAH02' 
UNION
select 'PAJ1','PAH03','IX_PAJ1_PAH03' 
UNION
select 'PAJ1','PAI01','IX_PAJ1_PAI01' 
UNION
select 'PAJ1','PAI03','IX_PAJ1_PAI03' 
UNION
select 'PAJ1','PAJ05','IX_PAJ1_PAJ05' 
UNION
select 'PAB1','PAA01','IX_PAB1_PAA01' 
UNION
select 'PAA1','PAA35','IX_PAA1_PAA35' 
UNION
select 'PAA1','PAA11','IX_PAA1_PAA11' 
UNION
select 'PAA1','PAA12','IX_PAA1_PAA12' 
UNION
select 'PAA1','VAA01','IX_PAA1_VAA01' 
UNION
select 'PAA1','PAA06','IX_PAA1_PAA06' 
UNION
select 'PAA1','PAA07','IX_PAA1_PAA07' 
UNION
select 'PAA1','PAA08','IX_PAA1_PAA08' 
UNION
select 'PAA1','ABBRP','IX_PAA1_ABBRP' 
UNION
select 'PAA1','ABBRW','IX_PAA1_ABBRW' 
UNION
select 'PAA1','BHF01A','IX_PAA1_BHF01A' 
UNION
select 'PAA1','PAA81','IX_PAA1_PAA81'
UNION
select 'PAA1','PAA80','IX_PAA1_PAA80'
UNION
select 'PAA1','BCK01A','IX_PAA1_BCK01A' 
UNION
select 'PAA1','PAA74','IX_PAA1_PAA74' 
UNION
select 'PAA1','PAA54','IX_PAA1_PAA54' 
UNION
select 'PAG1','PAA01','IX_PAG1_PAA01' 
UNION
select 'LAD1','LAB01','IX_LAD1_LAB01' 
UNION
select 'PAC1','PAA01','IX_PAC1_PAA01' 
UNION
select 'PAC1','PAC04','IX_PAC1_PAC04' 
UNION
select 'PAC1','PAB01','IX_PAC1_PAB01' 
UNION
select 'PAC1','PAC08','IX_PAC1_PAC08' 
UNION
select 'PAC1','PAC10','IX_PAC1_PAC10' 
UNION
select 'PAH1','PAA01','IX_PAH1_PAA01' 
UNION
select 'PAH1','PAH17','IX_PAH1_PAH17' 
UNION
select 'PAI1','PAH03','IX_PAI1_PAH03' 
UNION
select 'PAI1','PAA01','IX_PAI1_PAA01' 
UNION
select 'PAI1','PAI03','IX_PAI1_PAI03' 
UNION
select 'VAC4','VAC44','IX_VAC4_VAC44' 
UNION
select 'ZAA1','BCK01','IX_ZAA1_BCK01' 
UNION
select 'ZAA1','BCE01','IX_ZAA1_BCE01' 
UNION
select 'ZAA1','ZAA07','IX_ZAA1_ZAA07' 
UNION
select 'ZAA1','ZAA08','IX_ZAA1_ZAA08' 
UNION
select 'SCH1','SCA01','IX_SCH1_SCA01' 
UNION
select 'SCB1','SCA01','IX_SCB1_SCA01' 
UNION
select 'SYS_Parameters','ProductID','IX_SYS_Parameters_ProductID' 
UNION
select 'SYS_Parameters','ProgramID','IX_SYS_Parameters_ProgramID' 
UNION
select 'SYS_Parameters','ParamNo','IX_SYS_Parameters_ParamNo' 
UNION
select 'VDB1','VCN01','IX_VDB1_VCN01' 
UNION
select 'VDB1','BII01','IX_VDB1_BII01' 
UNION
select 'VDB1','BIJ01','IX_VDB1_BIJ01' 
UNION
select 'VDB1','BIJ01A','IX_VDB1_BIJ01A' 
UNION
select 'VCO1','VCN01','IX_VCO1_VCN01' 
UNION
select 'VCR1','VAF01','IX_VCR1_VAF01' 
UNION
select 'VCR1','VCO01','IX_VCR1_VCO01' 
UNION
select 'VCR1','BIJ01','IX_VCR1_BIJ01' 
UNION
select 'VAQ1','BCK01','IX_VAQ1_BCK01' 
UNION
select 'VAQ1','QAD01','IX_VAQ1_QAD01' 
UNION
select 'QAD1','BCE01','IX_QAD1_BCE01' 
UNION
select 'QAD1','QAD13','IX_QAD1_QAD13' 
union
select 'QAD1','VAQ01','IX_QAD1_VAQ01' 
union
select 'PED1','BKU01','IX_PED1_BKU01' 
UNION
select 'PED1','PEB01','IX_PED1_PEB01' 
union
select 'PED1','PEC01','IX_PED1_PEC01' 
UNION
select 'PED1','PED16','IX_PED1_PED16' 
union
select 'PED1','SCF01','IX_PED1_SCF01' 
union
select 'PAE1','PAE09','IX_PAE1_PAE09' 
union
select 'PAE1','PAE02','IX_PAE1_PAE02' 
union
select 'PAE1','BCK01','IX_PAE1_BCK01'
union
select 'PAE1','PAA01','IX_PAE1_PAA01' 
union
select 'PAE1','SCF01','IX_PAE1_SCF01' 
union
select 'VCB1','VBU01','IX_VCB1_VBU01' 
union
select 'VCB1','VCB04','IX_VCB1_VCB04' 
union
select 'VCA1','VBU01','IX_VCA1_VBU01' 
union
select 'VCA1','VAI01','IX_VCA1_VAI01' 
union
select 'VCA1','VBL01','IX_VCA1_VBL01' 
union
select 'VBU1','VAA01','IX_VBU1_VAA01' 
union
select 'VBU1','VCB04','IX_VBU1_VCB04' 
union
select 'VBU1','VBU23','IX_VBU1_VBU23' 
union
select 'VBU1','VCB01','IX_VBU1_VCB01' 
union
select 'VAA1','VAA02','IX_VAA1_VAA02' 
union
select 'LAK1','LAA01','IX_LAK1_LAA01' 
union
select 'VAF1_2','VAF01','IX_VAF1_2_VAF01' 
union
select 'VAF2_2','VAF01','IX_VAF2_2_VAF01' 
union
select 'VAF2','VAF01','IX_VAF2_VAF01_zy' 
union
select 'VBX1','VBX18','IX_VBX1_VBX18' 
union
select 'VCJ1','VCJ09','IX_VCJ1_BCE01A' 
union
select 'VBX1','BCE01A','IX_VBX1_BCE01A' 
union
select 'VAQ1','VAQ01A','IX_VAQ1_VAQ01A' 
union
select 'VCU1','VAQ01','IX_VCU1_VAQ01' 
union 
select 'VCD1','VAQ01','IX_VCD1_VAQ01' 
union 
select 'VBQ2','VAA01','IX_VBQ2_VAA01_' 
union 

select 'VBQ2','VAA07','IX_VBQ2_VAA07_' 
union 

select 'VBQ2','VBQ15','IX_VBQ2_VBQ15_' 
union
select 'VBD1_2','BBY01','IX_VBD1_2_BBY01' 
union 

select 'VBD1_2','VAF01','IX_VBD1_2_VAF01' 
union 
select 'VBD2_2','BBY01','IX_VBD2_2_BBY01' 
union 

select 'VBD2_2','VAF01','IX_VBD2_2_VAF01' 
union 
select 'VBI1_2','ACF01','IX_VBI1_2_ACF01' 
union 

select 'VBI1_2','VAA07','IX_VBI1_2_VAA07' 
union 

select 'VBI1_2','VAF01','IX_VBI1_2_VAF01' 
union 

select 'VBI1_2','VBI09','IX_VBI1_2_VBI09' 
union 

select 'VBI1_2','VBI10','IX_VBI1_2_VBI10' 
union
select 'VBI2_2','ACF01','IX_VBI2_2_ACF01' 
union 

select 'VBI2_2','VAA07','IX_VBI2_2_VAA07' 
union 

select 'VBI2_2','VAF01','IX_VBI2_2_VAF01' 
union 

select 'VBI2_2','VBI09','IX_VBI2_2_VBI09' 
union 

select 'VBI2_2','VBI10','IX_VBI2_2_VBI10' 
union
select 'VAO2','VAA01','IX_VAO2_VAA01' 
union 

select 'VAO2','VAA07','IX_VAO2_VAA07' 
union 

select 'VAO2','VAF01','IX_VAO2_VAF01' 
union 
select 'CBM1_2','ACF01','IX_CBM1_2_ACF01' 
union 

select 'CBM1_2','VAA01','IX_CBM1_2_VAA01' 
union 

select 'CBM1_2','VAA07','IX_CBM1_2_VAA07' 
union 

select 'CBM2_2','ACF01','IX_CBM2_2_ACF01' 
union 

select 'CBM2_2','VAA01','IX_CBM2_2_VAA01' 
union 

select 'CBM2_2','VAA07','IX_CBM2_2_VAA07' 
union 
select 'VAI1_2','CBM01','IX_VAI1_2_CBM01' 
union 

select 'VAI1_2','VAA01','IX_VAI1_2_VAA01' 
union 

select 'VAI2_2','CBM01','IX_VAI2_2_CBM01' 
union 

select 'VAI2_2','VAA01','IX_VAI2_2_VAA01' 
union 

select 'VAF1_2','BBX01','IX_VAF1_2_BBX01' 
union 

select 'VAF1_2','CBM01','IX_VAF1_2_CBM01' 
union 

select 'VAF1_2','VAA01','IX_VAF1_2_VAA01' 
union 

select 'VAF1_2','VAF01A','IX_VAF1_2_VAF01A' 
union 

select 'VAF1_2','VAF04','IX_VAF1_2_VAF04' 
union 

select 'VAF1_2','VAF06','IX_VAF1_2_VAF06' 
union 

select 'VAF1_2','VAF11','IX_VAF1_2_VAF11' 
union 

select 'VAF1_2','VAF36','IX_VAF1_2_VAF36' 
union 

select 'VAF1_2','VAF42','IX_VAF1_2_VAF42' 
union 

select 'VAF2_2','BBX01','IX_VAF2_2_BBX01' 
union 

select 'VAF2_2','CBM01','IX_VAF2_2_CBM01' 
union 

select 'VAF2_2','VAA01','IX_VAF2_2_VAA01' 
union 

select 'VAF2_2','VAF01A','IX_VAF2_2_VAF01A' 
union 

select 'VAF2_2','VAF04','IX_VAF2_2_VAF04' 
union 

select 'VAF2_2','VAF06','IX_VAF2_2_VAF06' 
union 

select 'VAF2_2','VAF11','IX_VAF2_2_VAF11' 
union 

select 'VAF2_2','VAF36','IX_VAF2_2_VAF36' 
union 

select 'VAF2_2','VAF42','IX_VAF2_2_VAF42' 
union 

select 'VAJ1_2','BBY01','IX_VAJ1_2_BBY01' 
union 

select 'VAJ1_2','BCK01D','IX_VAJ1_2_BCK01D' 
union 

select 'VAJ1_2','VAA01','IX_VAJ1_2_VAA01' 
union 

select 'VAJ1_2','VAA07','IX_VAJ1_2_VAA07' 
union 

select 'VAJ1_2','VAF01','IX_VAJ1_2_VAF01' 
union 

select 'VAJ1_2','VAI01','IX_VAJ1_2_VAI01' 
union 

select 'VAJ1_2','VAJ46','IX_VAJ1_2_VAJ46' 
union 

select 'VAJ1_2','VAJ48','IX_VAJ1_2_VAJ48' 
union 

select 'VAJ1_2','VAJ47','IX_VAJ1_2_VAJ47' 
union 

select 'VAJ1_2','VAK01','IX_VAJ1_2_VAK01' 
union 

select 'VAJ2_2','BBY01','IX_VAJ2_2_BBY01' 
union 

select 'VAJ2_2','BCK01D','IX_VAJ2_2_BCK01D' 
union 

select 'VAJ2_2','VAA01','IX_VAJ2_2_VAA01' 
union 

select 'VAJ2_2','VAA07','IX_VAJ2_2_VAA07' 
union 

select 'VAJ2_2','VAF01','IX_VAJ2_2_VAF01' 
union 

select 'VAJ2_2','VAI01','IX_VAJ2_2_VAI01' 
union 

select 'VAJ2_2','VAJ46','IX_VAJ2_2_VAJ46' 
union 

select 'VAJ2_2','VAJ48','IX_VAJ2_2_VAJ48' 
union 

select 'VAJ2_2','VAJ47','IX_VAJ2_2_VAJ47' 
union 

select 'VAJ2_2','VAK01','IX_VAJ2_2_VAK01' 
union 
select 'VAC1','VAC72','IX_VAC1_VAC72' 
union 
select 'SCF1','SCF10','IX_SCF1_SCF10' 
union 
select 'SCF1','SCA01','IX_SCF1_SCA01' 
union 
select 'LAA1','LAA08','IX_LAA1_LAA08' 
union 

select 'VBX1','BCK01C','IX_VBX1_BCK01C' 
union 

select 'VBX1','BCK01D','IX_VBX1_BCK01D' 
union 

select 'VBX1','VBX03','IX_VBX1_VBX03' 
union 

select 'VBX1','VBX22','IX_VBX1_VBX22' 
union 

select 'VBZ1','VAA07','IX_VBZ1_VAA07' 
union 

select 'VBQ1','VAA01','IX_VBQ1_VAA01' 
union 

select 'VBQ1','VAA07','IX_VBQ1_VAA07' 
union 

select 'VBQ1','VBQ15','IX_VBQ1_VBQ15' 
union 

select 'VCN1','VAA01','IX_VCN1_VAA01' 
union 

select 'VCN1','VAA07','IX_VCN1_VAA07' 
union 

select 'IAS1','VAK01','IX_IAS1_VAK01' 
union
select 'IAS1','IAS28','IX_IAS1_IAS28' 
union
select 'IAS1','IAR01','IX_IAS1_IAR01' 
union
select 'IAR1','VAA07','IX_IAR1_VAA07' 
union

select 'IAQ1','VAJ01','IX_IAQ1_VAJ01' 
union

select 'IAQ1','IAS01','IX_IAQ1_IAS01' 
union

select 'PEJ1','SCA01','IX_PEJ1_SCA01' 
union

select 'PEJ1','SCF01','IX_PEJ1_SCF01' 
union

select 'PEJ1','PEJ10','IX_PEJ1_PEJ10' 
union 

select 'PEJ1','PEJ29','IX_PEJ1_PEJ29' 
union 

select 'PEJ1','BCK01B','IX_PEJ1_BCK01B' 
union 

select 'PEJ1','VBQ01','IX_PEJ1_VBQ01' 
union 

select 'PEM1','PEJ01','IX_PEM1_PEJ01' 
union 

select 'PEM1','SCF01','IX_PEM1_SCF01' 
union 

select 'PEM1','VAI01','IX_PEM1_VAI01' 
union 

select 'PEN1','PEJ01','IX_PEN1_PEJ01' 
union 

select 'PEN1','SCF01','IX_PEN1_SCF01' 
union 

select 'PEN1','BBX01','IX_PEN1_BBX01' 
union 

select 'PEO1','PEJ01','IX_PEO1_PEJ01' 
union 

select 'PEO1','SCF01','IX_PEO1_SCF01' 
union 

select 'PEO1','BBX01','IX_PEO1_BBX01' 
union 

select 'DPB2','BBY01','IX_DPB2_BBY01' 
union 

select 'BCT1','BBX01','IX_BCT1_BBX01' 
union 

select 'SYS_UserRoles','UserID','IX_SYS_UserRoles_UserID' 
union 

select 'VAJ1','BBY01','IX_VAJ1_BBY01' 
union 

select 'VAJ1','BCK01D','IX_VAJ1_BCK01D' 
union 

select 'VAJ1','VAA01','IX_VAJ1_VAA01' 
union 

select 'VAJ1','VAA07','IX_VAJ1_VAA07' 
union 

select 'VAJ1','VAF01','IX_VAJ1_VAF01' 
union 

select 'VAJ1','VAI01','IX_VAJ1_VAI01' 
union 

select 'VAJ1','VAJ09','IX_VAJ1_VAJ09' 
union 

select 'VAJ1','VAJ46','IX_VAJ1_VAJ46' 
union 

select 'VAJ1','VAJ47','IX_VAJ1_VAJ47' 
union 

select 'VAJ1','VAJ48','IX_VAJ1_VAJ48' 
union 

select 'VAJ1','VAK01','IX_VAJ1_VAK01' 
union 

select 'VAD1','VAC01','IX_VAD1_VAC01' 
union 

select 'VAD1','VAD03','IX_VAD1_VAD03' 
union 

select 'SYS_UserPermissions','UserID','IX_SYS_UserPermissions_UserID' 
union 

select 'DPD1','AuditingDate','IX_DPD1_AuditingDate' 
union 

select 'DPD1','TradeID','IX_DPD1_TradeID' 
union 

select 'VAC1','VAA01','IX_VAC1_VAA01' 
union 

select 'VAC1','VAC02','IX_VAC1_VAC02' 
union 

select 'VAC1','VAC35','IX_VAC1_VAC35' 
union 

select 'VAC1','VAC36','IX_VAC1_VAC36' 
union 
select 'VAC1','BCK01A','IX_VAC1_BCK01A' 
union 
select 'VAC1','BCE01A','IX_VAC1_BCE01A' 
union 
select 'VAC1','BAS02A','IX_VAC1_BAS02A' 
union 
select 'VAC1','VAC74','IX_VAC1_VAC74' 
union 
select 'VAC1','VAC75','IX_VAC1_VAC75' 
union 
select 'VAC1','VAC77','IX_VAC1_VAC77' 
union 
select 'DPD1_2','AuditingDate','IX_DPD1_2_AuditingDate' 
union 

select 'DPD1_2','TradeID','IX_DPD1_2_TradeID' 
union 

select 'IAT1','IAS01','IX_IAT_IAS01' 
union 

select 'FAB1','FAA01','IX_FAB1_FAA01' 
union 

select 'FAB1','FAB03','IX_FAB1_FAB03' 
union 

select 'FAB1','FAC01','IX_FAB1_FAC01' 
union 

select 'SYS_RolePermissions','ElementID','IX_SYS_RolePermissions_ElementID' 
union 

select 'SYS_RolePermissions','RoleID','IX_SYS_RolePermissions_RoleID' 
union 

select 'FAC1','FAC03','IX_FAC1_FAC03' 
union 

select 'FAC1','FAC04','IX_FAC1_FAC04' 
union 

select 'FAF1','FAF01A','IX_FAF1_FAF01A' 
union 

select 'FAF1','FAF01C','IX_FAF1_FAF01C' 
union 

select 'BCL1','ABBRP','IX_BCL1_ABBRP' 
union 

select 'BCL1','ABBRW','IX_BCL1_ABBRW' 
union 

select 'BCL1','BBY01','IX_BCL1_BBY01' 
union 

select 'BCL1','BCL03','IX_BCL1_BCL03' 
union 

select 'DPD2_2','VAJ01','IX_DPD2_2_VAJ01' 
union 

select 'BCO1','BCO02','IX_BCO1_BCO02' 
union 

select 'BCO1','BCO03','IX_BCO1_BCO03' 
union 

select 'BCO1','BCO04','IX_BCO1_BCO04' 
union 

select 'VAO2','VAA01','IX_VAO2_VAA01' 
union 

select 'VAO2','VAA07','IX_VAO2_VAA07' 
union 

select 'VAO2','VAF01','IX_VAO2_VAF01' 
union 

select 'VAE1','VAA01','IX_VAE1_VAA01' 
union
select 'VAE1','VAE94','IX_VAE1_VAE94' 
union  
select 'VAE1','VAE95','IX_VAE1_VAE95' 
union  
select 'VAE1','VAE98','IX_VAE1_VAE98' 
union 
select 'VAE1','BCK01A','IX_VAE1_BCK01A' 
union 
select 'VAE1','BCK01B','IX_VAE1_BCK01B' 
union 
select 'VAE1','BCK01C','IX_VAE1_BCK01C' 
union 
select 'VAE1','BCE02C','IX_VAE1_BCE02C' 
union 
select 'VAE1','BCK01D','IX_VAE1_BCK01D' 
union
select 'VAE1','BCQ04B','IX_VAE1_BCQ04B' 
union
select 'VAE1','VAE11','IX_VAE1_VAE11' 
union 

select 'VAE1','VAE26','IX_VAE1_VAE26' 
union 

select 'BBY1','ABF01','IX_BBY1_ABF01' 
union 

select 'BBY1','BAX01','IX_BBY1_BAX01' 
union 

select 'BBY1','BBY05','IX_BBY1_BBY05' 
union 

select 'BBY1','BBY31','IX_BBY1_BBY31' 
union 

select 'BBY1','BDN01','IX_BBY1_BDN01' 
union 

select 'BCR1','BBY01A','IX_BCR1_BBY01A' 
union 

select 'BCR1','BBY01B','IX_BCR1_BBY01B' 
union 

select 'FAB2','FAA01','IX_FAB2_FAA01' 
union 

select 'FAB2','FAC01','IX_FAB2_FAC01' 
union 

select 'VAI7','CBM01','IX_VAI7_CBM01' 
union 

select 'VAI7','VAA01','IX_VAI7_VAA01' 
union 

select 'VAI7','VAA07','IX_VAI7_VAA07' 
union 

select 'VBJ1','VAF01','IX_VBJ1_VAF01' 
union 

select 'FAC2','FAC03','IX_FAC2_FAC03' 
union 

select 'FAC2','FAC04','IX_FAC2_FAC04' 
union 

select 'VAK7','BCE01A','IX_VAK7_BCE01A' 
union 

select 'VAK7','VAA01','IX_VAK7_VAA01' 
union 

select 'VAK7','VAA07','IX_VAK7_VAA07' 
union 

select 'VAK7','VAK13','IX_VAK7_VAK13' 
union 

select 'VAK7','VAK18','IX_VAK7_VAK18' 
union 

select 'VAQ1','VAA01','IX_VAQ1_VAA01' 
union 

select 'VAQ1','VAA07','IX_VAQ1_VAA07' 
union 

select 'VBL7','VAA01','IX_VBL7_VAA01' 
union 

select 'VBL7','VAA07','IX_VBL7_VAA07' 
union 

select 'VBL7','VAK01','IX_VBL7_VAK01' 
union 

select 'VBL7','VBL17','IX_VBL7_VBL17' 
union 
select 'VBL1','VBL18','IX_VBL1_VBL18' 
union 
select 'VBL2','VBL18','IX_VBL2_VBL18' 
union 

select 'VAI1','CBM01','IX_VAI1_CBM01' 
union 

select 'VAI1','VAA01','IX_VAI1_VAA01' 
union 

select 'VAI1','VAA07','IX_VAI1_VAA07' 
union 

select 'VAI1','VAK01','IX_VAI1_VAK01' 
union 

select 'LAB1','LAB09','IX_LAB1_LAB09' 
union 

select 'LAB1','LAB60','IX_LAB1_LAB60' 
union 

select 'LAB1','VAA05','IX_LAB1_VAA05' 
union 

select 'LAB1','VAF01','IX_LAB1_VAF01' 
union 
select 'LAB2','LAB09','IX_LAB2_LAB09' 
union 

select 'LAB2','LAB60','IX_LAB2_LAB60' 
union 

select 'LAB2','VAA05','IX_LAB2_VAA05' 
union 

select 'LAB2','VAF01','IX_LAB2_VAF01' 
union 
select 'LAB1','LAB32','IX_LAB1_LAB32' 
union 
select 'LAB2','LAB32','IX_LAB2_LAB32' 
union 

select 'VAK1','BCE01A','IX_VAK1_BCE01A' 
union 

select 'VAK1','VAK28','IX_VAK1_VAK28' 
union 

select 'VAK1','VAA07','IX_VAK1_VAA07' 
union 

select 'VAK1','VAI04','IX_VAK1_VAI04' 
union 

select 'VAK1','VAK01','IX_VAK1_VAK01' 
union 

select 'VAK1','VAK13','IX_VAK1_VAK13' 
union 

select 'VAK1','VAK18','IX_VAK1_VAK18' 
union 

select 'LAC1','BBX01','IX_LAC1_BBX01' 
union 

select 'LAC1','LAB01','IX_LAC1_LAB01' 
union 

select 'VAF7','BBX01','IX_VAF7_BBX01' 
union 

select 'VAF7','VAF06','IX_VAF7_VAF06' 
union 

select 'VAF7','VAF36','IX_VAF7_VAF36' 
union 

select 'BAZ1','BAU01','Ix_BAZ1_BAU01' 
union 

select 'BAZ1','BCK01','Ix_BAZ1_BCK01' 
union 

select 'VCF1','VAA01','IX_VCF1_VAA01' 
union 

select 'VCF1','VAA07','IX_VCF1_VAA07' 
union 

select 'VCF1','VAP01','IX_VCF1_VAP01' 
union 

select 'VCF1','VCF09','IX_VCF1_VCF09' 
union 

select 'VBI7','VAF01','IX_VBI7_VAF01' 
union 

select 'VBI7','VBI10','IX_VBI7_VBI10' 
union 

select 'VAI2','CBM01','IX_VAI2_CBM01' 
union 

select 'VAI2','VAA01','IX_VAI2_VAA01' 
union 

select 'VAI2','VAA07','IX_VAI2_VAA07' 
union 
select 'VAI2','VAK01','IX_VAI2_VAK01' 
union 
select 'CBM7','VAA01','IX_CBM7_VAA01' 
union 

select 'CBM7','VAA07','IX_CBM7_VAA07' 
union 

select 'BAI1','BCK01','IX_BAI1_BCK01' 
union 

select 'BAI1','BCO02','IX_BAI1_BCO02' 
union 

select 'VBD7','BBY01','IX_VBD7_BBY01' 
union 

select 'VBD7','VAF01','IX_VBD7_VAF01' 
union 

select 'VAJ2','ACF01','IX_VAJ2_ACF01' 
union 

select 'VAJ2','BBY01','IX_VAJ2_BBY01' 
union 

select 'VAJ2','BCK01D','IX_VAJ2_BCK01D' 
union 

select 'VAJ2','VAA01','IX_VAJ2_VAA01' 
union 

select 'VAJ2','VAA07','IX_VAJ2_VAA07' 
union 

select 'VAJ2','VAF01','IX_VAJ2_VAF01' 
union 

select 'VAJ2','VAI01','IX_VAJ2_VAI01' 
union 

select 'VAJ2','VAJ46','IX_VAJ2_VAJ46' 
union 

select 'VAJ2','VAJ48','IX_VAJ2_VAJ48' 
union 

select 'VAJ2','VAJ47','IX_VAJ2_VAJ47' 
union 

select 'VAJ2','VAK01','IX_VAJ2_VAK01' 
union 

select 'BDK1','ABBRP','IX_BDK1_ABBRP' 
union 

select 'BDK1','ABBRW','IX_BDK1_ABBRW' 
union 

select 'BDK1','BBX01','IX_BDK1_BBX01' 
union 

select 'BDK1','BDK03','IX_BDK1_BDK03' 
union 

select 'VAO1','VAA01','IX_VAO1_VAA01' 
union 

select 'VAO1','VAA07','IX_VAO1_VAA07' 
union 

select 'VAO1','VAF01','IX_VAO1_VAF01' 
union 

select 'VAK2','BCE01A','IX_VAK2_BCE01A' 
union 

select 'VAK2','VAA01','IX_VAK2_VAA01' 
union 

select 'VAK2','VAA07','IX_VAK2_VAA07' 
union 

select 'VAK2','VAK06','IX_VAK2_VAK06' 
union 

select 'VAK2','VAK13','IX_VAK2_VAK13' 
union 

select 'VAK2','VAK18','IX_VAK2_VAK18' 
union 

select 'LAC2','BBX01','IX_LAC2_BBX01' 
union 

select 'LAC2','LAB01','IX_LAC2_LAB01' 
union 

select 'VBL2','VAA07','IX_VBL2_VAA07' 
union 

select 'VBL2','VAK01','IX_VBL2_VAK01' 
union 

select 'VBL2','VBL17','IX_VBL2_VBL17' 
union 

select 'VBL2','VBL19','IX_VBL2_VBL19' 
union 

select 'IBD1','IAS01','IX_IBD1_IAS01' 
union 

select 'BBJ1','BBY01','IX_BBJ1_BBY01' 
union 

select 'BBJ1','BCK01A','IX_BBJ1_BCK01A' 
union 

select 'BBJ1','BCK01B','IX_BBJ1_BCK01B' 
union 

select 'IBE1','IAS01','IX_IBE1_IAS01' 
union 

select 'VAF1','BBX01','IX_VAF1_BBX01' 
union 

select 'VAF1','BBY01','IX_VAF1_BBY01' 
union 

select 'VAF1','CBM01','IX_VAF1_CBM01' 
union 

select 'VAF1','VAF01A','IX_VAF1_VAF01A' 
union 
select 'VAF1','BCK01B','IX_VAF1_BCK01B' 
union 
select 'VAF2','BCK01B','IX_VAF2_BCK01B' 
union 
select 'VAF1','VAF06','IX_VAF1_VAF06' 
union 

select 'VAF1','VAF36','IX_VAF1_VAF36' 
union 

select 'VAF1','VAF42','IX_VAF1_VAF42' 
union 

select 'VAF2','BBX01','IX_VAF2_BBX01' 
union 

select 'VAF2','CBM01','IX_VAF2_CBM01' 
union 

select 'VAF2','VAA01','IX_VAF2_VAA01' 
union 

select 'VAF2','VAF01A','IX_VAF2_VAF01A' 
union 

select 'VAF2','VAF04','IX_VAF2_VAF04' 
union 

select 'VAF2','VAF06','IX_VAF2_VAF06' 
union 
select 'VAF2','VAF11','IX_VAF2_VAF11' 
union 
select 'VAF2','VAF36','IX_VAF2_VAF36' 
union 
select 'VAF2','VAF42','IX_VAF2_VAF42' 
union 
select 'IBF1','IAS01','IX_IBF1_IAS01' 
union 
select 'Core_Programs','ComponentID','IX_Core_Programs_ComponentID' 
union 
select 'ZAE1','CNAME','IX_ZAE1_CNAME' 
union 
select 'ZAE1','ZAE04','IX_ZAE1_ZAE04' 
union
select 'ZAE1','ZAE05','IX_ZAE1_ZAE05' 
union
select 'ZAE1','TNAME','IX_ZAE1_TNAME' 
union 
select 'ZAE1','ZAE11','IX_ZAE1_ZAE11' 
union 
select 'CBM1','ACF01','IX_CBM1_ACF01' 
union 

select 'CBM1','VAA01','IX_CBM1_VAA01' 
union 

select 'CBM1','VAA07','IX_CBM1_VAA07' 
union 
select 'CBM2','ACF01','IX_CBM2_ACF01' 
union 

select 'CBM2','VAA01','IX_CBM2_VAA01' 
union 

select 'CBM2','VAA07','IX_CBM2_VAA07' 
union 

select 'VBI2','ACF01','IX_VBI2_ACF01' 
union 

select 'VBI2','VAA07','IX_VBI2_VAA07' 
union 

select 'VBI2','VAF01','IX_VBI2_VAF01' 
union 

select 'VBI2','VBI09','IX_VBI2_VBI09' 
union 

select 'VBI2','VBI10','IX_VBI2_VBI10' 
union 

select 'VBD2','BBY01','IX_VBD2_BBY01' 
union 

select 'VBD2','VAF01','IX_VBD2_VAF01' 
union 

select 'Core_ProgramElements','ProgramID','IX_Core_ProgramElements_ProgramID' 
union 

select 'BBX1','BBX25','IX_BBX1_BBX25' 
union 

select 'VCM1','VAA07','IX_VCM1_VAA07' 
union 

select 'VCM1','VAF01','IX_VCM1_VAF01' 
union 

select 'VCM1','VBI01','IX_VCM1_VBI01' 
union 

select 'VCC1','VAQ01','IX_VCC1_VAQ01' 
union 

select 'VBI1','VAF01','IX_VBI1_VAF01' 
union 

select 'VBI1','VBI09','IX_VBI1_VBI09' 
union 

select 'VBI1','VBI10','IX_VBI1_VBI10' 
union 

select 'VAA1','VAA02','IX_VAA1_VAA02' 
union 

select 'VAA1','VAA03','IX_VAA1_VAA03' 
union 

select 'VAA1','VAA04','IX_VAA1_VAA04' 
union 

select 'VAA1','VBU01','IX_VAA1_VBU01' 
union 
select 'VAA1','VAA15','IX_VAA1_VAA15' 
union 
select 'VAA1','ABBRP','IX_VAA1_ABBRP' 
union 
select 'VAA1','VAA34','IX_VAA1_VAA34' 
union
select 'VAA1','VAA35','IX_VAA1_VAA35' 
union
select 'BAG1','BBX01','IX_BAG1_BBX01' 
union 

select 'DSD2','BBY01','IX_DSD2_BBY01' 
union 

select 'VBL1','VAA07','IX_VBL1_VAA07' 
union 

select 'VBL1','VAK01','IX_VBL1_VAK01' 
union 

select 'VBL1','VBL02','IX_VBL1_VBL02' 
union 

select 'VBL1','VBL17','IX_VBL1_VBL17' 
union 

select 'VBL1','VBL19','IX_VBL1_VBL19' 
union 

select 'FAD1','FAD12','IX_FAD1_FAD12' 
union 

select 'FAD1','FAD15','IX_FAD1_FAD15' 
union 

select 'FAE1','FAA01','IX_FAE1_FAA01' 
union 

select 'FAE1','FAB03','IX_FAE1_FAB03' 
union 

select 'FAE1','DFLAG','IX_FAE1_DFLAG' 


--从表变量中去掉已经存在索引
delete t from @table1 t where exists(
SELECT 0 FROM sys.indexes  a
join  sys.index_columns b on a.object_id=b.object_id and a.index_id=b.index_id
join sys.all_columns c on a.object_id=c.object_id and c.column_id=b.column_id
join sys.objects d on a.object_id=d.object_id 
WHERE  (d.type='U' and is_primary_key=0 and is_unique=0 and t.tname=OBJECT_NAME(a.object_id) and 

t.cname=c.name) or UPPER(RTRIM('IX_'+t.tname+'_'+t.cname))=UPPER(RTRIM(a.name)))
or not exists(select * from V_COL where tname=t.tname and cname=t.cname)
--添加缺少的索引
declare @maxid int,@str varchar(1000),@i int
select IDENTITY(int,1,1) id ,* into #lost from @table1
select @maxid=max(id),@i=1 from #lost
while(@i<=@maxid)
begin
	SELECT @str='CREATE INDEX '+'IX_'+tname+'_'+cname+' ON '+ tname+'('+ cname+')' FROM #lost where ID=@i
	exec(@str)
	set @i=@i+1
end
drop table #lost







GO
exec SYS_ADDIndex