dbo.QBM_PSchemaBindDisable

1  create   procedure QBM_PSchemaBindDisable (@TableName nvarchar(64) ) as begin declare @SQLcmd nvarchar(max) declare @ObjectName nvarchar(64) declare
2 @ObjectType nvarchar(2) declare @ScriptCode nvarchar(max) declare @Elements QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex int SET 
3XACT_ABORT OFF BEGIN TRY set nocount on insert into @Elements (LongIdent1 , Ident1 , ContentFull ) select ObjectName, ObjectType, SourceCode from dbo.QBM_FTSchemaDependencies
4 (@TableName, 1) where ObjectType in ('F', 'V') select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select
5 top 1 @ObjectName = bu.LongIdent1 , @ObjectType = bu.Ident1 , @ScriptCode = bu.ContentFull from @elements bu where bu.ElementIndex = @ElementIndex if 
6@ObjectType = 'V' begin select @SQLcmd = concat('drop view if exists ', @ObjectName) end else begin select @SQLcmd = concat('drop function if exists dbo.'
7, @ObjectName) end exec sp_executesql @SQLcmd select @SQLcmd = replace(@ScriptCode, 'with schemabinding', ' ') exec sp_executesql @SQLcmd select @ElementIndex
8 += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow,
9 18, 1) WITH NOWAIT END CATCH endLabel: return end 
10