dbo.QBM_PColumnSchemaDataTypeCorr

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
`@ModulePattern`	varchar	no

Referenced objects

Schema	Object	Class
	DialogColumn	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
dbo	QBM_FCVGUIDToModuleOwner	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_OR_COLUMN

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   procedure QBM_PColumnSchemaDataTypeCorr (@ModulePattern varchar(3) = '%' ) as begin declare @XUser nvarchar(64) = object_name(@@procid
2) declare @Xdate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY update DialogColumn set SchemaDataType = x.DATA_TYPE  , XDateUpdated = @Xdate , XUserUpdated
3 = @XUser , SchemaDataLen = case when x.CHARACTER_MAXIMUM_LENGTH is null then 0 else x.CHARACTER_MAXIMUM_LENGTH end from DialogColumn c join DialogTable
4 t on c.UID_DialogTable = t.UID_DialogTable join INFORMATION_SCHEMA.COLUMNS x on t.TableName = x.TABLE_NAME and c.ColumnName = x.COLUMN_NAME where ( isnull
5(c.SchemaDataType, '') <> x.DATA_TYPE or isnull(c.SchemaDataLen, 0) <> isnull(x.CHARACTER_MAXIMUM_LENGTH, 0) or c.SchemaDataLen is null ) and dbo.QBM_FCVGUIDToModuleOwner
6(c.uid_dialogColumn) like @ModulePattern END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
7() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 
8

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:20:26.150

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes UPDATE DialogColumn; reads/joins DialogColumn, DialogTable, INFORMATION_SCHEMA

Declared parameters

Parameter	Type	Direction
`@ModulePattern`	`varchar(3)`	input

DML targets

UPDATE DialogColumn

Called routines

QBM_PSessionErrorAdd

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @ModulePattern @XUser @procid @Xdate @Rethrow

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_PDatabasePrepareCheck1	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QBM_PDatabasePrepareCheck1	source text reference	has TRY/CATCH error handling