dbo.QBM_PIndexCreateGenerated

1       create   procedure QBM_PIndexCreateGenerated ( @TablePattern varchar(64) , @ModuleNameOrPattern varchar(16) = '%'  ) as begin declare @TableName
2 varchar(30) declare @Names table (TableName varchar(30) collate database_default ) declare @DebugSwitch int = 0 SET XACT_ABORT OFF BEGIN TRY insert into
3 @Names(TableName) select t.TableName from DialogTable t where t.TableType in ('B', 'T') and t.TableName like @TablePattern and dbo.QBM_FCVGUIDToModuleOwner
4(t.UID_DialogTable) like @ModuleNameOrPattern select @TableName = '#' while @TableName > ' ' begin select @TableName = null select top 1 @TableName = n.TableName
5 from @Names n if @TableName is null begin continue end delete  @Names where TableName = @TableName if @DebugSwitch > 0 begin print @tablename end     
6    exec QBM_PIndexCreateGenerated_XO @TableName    exec QBM_PIndexCreateGenerated_XI @TableName    exec QBM_PIndexCreateGenerated_XR @TableName    exec
7 QBM_PIndexCreateGenerated_XA @TableName     exec QBM_PIndexCreateGenerated_XX @TableName  exec QBM_PIndexDropRedundant @TableName end  END TRY BEGIN CATCH
8 exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH 
9ende: return end 
10