dbo.QBM_FTRelationValidationInfo
SQL_INLINE_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:14:10.630 · modified 2026-04-14T23:14:10.630 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| No parameters. | ||
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.
1create function dbo.QBM_FTRelationValidationInfo () returns table with SCHEMABINDING as return( select RIType, ChildType, Parenttype, IsValid, IsInModel 2, useForRI, useForObjectwalker, HasBaserelation , ValidChildExecuteBy, ValidParentExecuteBy from ( values ('Fix' ,'B' ,'B' ,1 ,1 ,1 ,0 ,0 ,'NT' ,'NT' 3) ,('Fix' ,'B' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'T' ,1 ,1 ,1 ,0 ,0 ,'NT' ,'TDN') ,('Fix' ,'B' ,'V' ,1 ,1 ,1 ,0 ,1 ,'T' ,'TDN') ,('Fix' ,'B' 4 ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'B' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'B' ,0 ,0 ,0 ,0 ,0 5 ,'N' ,'N') ,('Fix' ,'M' ,'M' ,1 ,1 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Fix' ,'M' ,'T' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'V' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' 6 ,'M' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'M' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'B' ,1 ,0 ,1 7 ,0 ,0 ,'TDN' ,'TN') ,('Fix' ,'T' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'T' ,1 ,1 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Fix' ,'T' ,'V' ,1 ,1 ,1 ,1 ,1 ,'TDN' 8 ,'TDN') ,('Fix' ,'T' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'T' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' 9 ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'T' ,1 ,1 ,1 ,1 ,1 ,'TDN' ,'TDN') ,('Fix' ,'V' ,'V' ,1 ,0 ,0 10 ,1 ,0 ,'ND' ,'ND') ,('Fix' ,'V' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'V' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') 11 ,('Fix' ,'P' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'V' 12,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'P' ,1 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'P' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' 13 ,'N') ,('Fix' ,'U' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' 14 ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'U' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'U' ,'R' ,0 ,0 ,0 ,0 15 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'B' ,1 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,( 16'Fix' ,'R' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'U' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Fix' ,'R' ,'R' ,1 17,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'T' ,0 ,0 ,0 ,0 ,0 ,'N' 18 ,'N') ,('Dyn' ,'B' ,'V' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'B' 19 ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'T' ,0 ,0 ,0 ,0 ,0 20 ,'N' ,'N') ,('Dyn' ,'M' ,'V' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'M' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' 21 ,'M' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'T' ,1 ,0 ,1 22 ,1 ,0 ,'TD' ,'TD') ,('Dyn' ,'T' ,'V' ,1 ,0 ,1 ,1 ,0 ,'TD' ,'TDN') ,('Dyn' ,'T' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'T' ,'U' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N' 23) ,('Dyn' ,'T' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'M' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'T' 24 ,1 ,0 ,1 ,1 ,0 ,'TDN' ,'TD') ,('Dyn' ,'V' ,'V' ,1 ,0 ,1 ,1 ,0 ,'TDN' ,'TDN') ,('Dyn' ,'V' ,'P' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'U' ,0 ,0 ,0 ,0 25 ,0 ,'N' ,'N') ,('Dyn' ,'V' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' 26 ,'P' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'U' ,0 ,0 ,0 27 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'P' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') , 28('Dyn' ,'U' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'U' ,1 29 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'U' ,'R' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'B' ,0 ,0 ,0 ,0 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'M' ,1 ,0 ,0 ,1 ,0 ,'N' , 30'N') ,('Dyn' ,'R' ,'T' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'V' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'P' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' , 31'U' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ,('Dyn' ,'R' ,'R' ,1 ,0 ,0 ,1 ,0 ,'N' ,'N') ) x (RIType, ChildType, Parenttype, IsValid, IsInModel, useForRI, useForObjectwalker 32, HasBaserelation , ValidChildExecuteBy, ValidParentExecuteBy) ) 33
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.630
None extracted.
Summary: No calls/DML/dependency patterns extracted by the current parser.
Declared parameters
No declared parameters in sys.parameters for this object, or metadata was not available.
DML targets
None extracted.Called routines
None extracted.
Read/join references
None extracted.
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: None extracted.
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_PQBMRelationCheck | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PRelationshipDefineManual | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PQBMRelationCheck | source text reference | has TRY/CATCH error handling |
| dbo.QBM_PRelationshipDefineManual | source text reference | SQL_STORED_PROCEDURE |