dbo.QBM_FGIColumnExistsInSchema

SQL_SCALAR_FUNCTION

Created 2025-06-27T17:57:01.613 · modified 2026-04-14T23:14:10.540 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
	bit	yes
`@TableName`	varchar	no
`@ColumnPattern`	varchar	no

Referenced objects

Schema	Object	Column/minor	Class
No SQL expression dependencies in snapshot.

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1    create   function dbo.QBM_FGIColumnExistsInSchema (@TableName varchar(30) , @ColumnPattern varchar(30) ) returns bit  as begin return ( case
2 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 = @TableName
3 and c.name like @ColumnPattern ) then 1 else 0 end ) end 
4

Module relation graph

Loading module relation graph…

Source-derived context

Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.

provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:14:10.540

None extracted.

Summary: reads/joins sys

Declared parameters

Parameter	Type	Direction
	`bit`	OUTPUT
`@TableName`	`varchar(30)`	input
`@ColumnPattern`	`varchar(30)`	input

DML targets

None extracted.

Called routines

None extracted.

Read/join references

SQL dependency metadata

None extracted.

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @TableName @ColumnPattern

Referenced by / reverse dependencies

Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.

Referencing object	Relation	Evidence
dbo.QBM_FSQFKCheckDynamic	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FSQFKCheckFix	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FSQTriggerWatchXOrigin	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_FSQXMarkedForDeletionChg	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.DPR_PMemberShipActionCleanUp	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferC_ProcessOneColumn	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferC_RestoreOneColumn	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PBufferT_ProcessUpdate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PCheckSameCase_138	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PCheckSameCase_38	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PColumnChangeDataType	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PColumnSQLReplace	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PDeleteDeep_L	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PFDA25F6EA8E748702E6D119_1	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PForeignKeyEmptySetNull	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PForeignKeyObjectKeyNoRef	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PGUIDReplaceLight_Multi	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_PXDateSubItemUpdate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZCheckDefaultZero	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZCheckInvalidDate	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZObjectKeyRepair	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QBM_ZXMarkedForDeletionPush	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove_bulk	SQL expression dependency	dbo · OBJECT_OR_COLUMN
dbo.QER_PQERRiskIndexMakeProc	SQL expression dependency	dbo · OBJECT_OR_COLUMN