dbo.QBM_FGIColumnExistsInSchema
Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB
Interpretation
- Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.
Relations
- No extracted relations.
Typed Edges
- references source dbo.QBM_FGIColumnExists source text reference
References
Referenced By
- dbo.QBM_FSQFKCheckDynamic
- dbo.QBM_FSQFKCheckFix
- dbo.QBM_FSQTriggerWatchXOrigin
- dbo.QBM_FSQXMarkedForDeletionChg
- dbo.DPR_PMemberShipActionCleanUp
- dbo.QBM_PBufferC_ProcessOneColumn
- dbo.QBM_PBufferC_RestoreOneColumn
- dbo.QBM_PBufferT_ProcessUpdate
- dbo.QBM_PCheckSameCase_138
- dbo.QBM_PCheckSameCase_38
- dbo.QBM_PColumnChangeDataType
- dbo.QBM_PColumnSQLReplace
- dbo.QBM_PDeleteDeep_L
- dbo.QBM_PFDA25F6EA8E748702E6D119_1
- dbo.QBM_PForeignKeyEmptySetNull
- dbo.QBM_PForeignKeyObjectKeyNoRef
- dbo.QBM_PGUIDReplaceLight_Multi
- dbo.QBM_PXDateSubItemUpdate
- dbo.QBM_ZCheckDefaultZero
- dbo.QBM_ZCheckInvalidDate
- dbo.QBM_ZObjectKeyRepair
- dbo.QBM_ZXMarkedForDeletionPush
- dbo.QER_PITShopOrderMove_bulk
- dbo.QER_PQERRiskIndexMakeProc
Complete Source
1CREATE FUNCTION dbo.QBM_FGIColumnExistsInSchema(2 @TableName varchar(30),3 @ColumnPattern varchar(30)4) RETURNS BIT5AS6BEGIN7 RETURN(CASE8 WHEN EXISTS(9 SELECT TOP 1 110 FROM sys.tables t11 WITH(readpast)12 JOIN sys.columns c13 WITH(readpast)14 ON t.object_id = c.object_id15 WHERE16 t.name = @TableName AND c.name LIKE @ColumnPattern) THEN17 118 ELSE 019 END)20ENDOpen raw exported source
1 create function dbo.QBM_FGIColumnExistsInSchema (@TableName varchar(30) , @ColumnPattern varchar(30) ) returns bit as begin return ( case2 when exists (select top 1 1 from sys.tables t with (readpast) join sys.columns c with (readpast) on t.object_id = c.object_id where t.name = @TableName3 and c.name like @ColumnPattern ) then 1 else 0 end ) end 4