dbo.DPR_FTSchemaAccessChildren
SQL_TABLE_VALUED_FUNCTION
Created 2026-04-14T23:16:47.173 · modified 2026-04-14T23:16:47.173 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@UID_Property1 | varchar | no |
@UID_Property2 | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | DPRSchemaAccess | OBJECT_OR_COLUMN | |
| dbo | DPRSchemaAccess | UID_DPRSchemaPropertyTrg | OBJECT_OR_COLUMN |
| dbo | DPRSchemaAccess | UID_DPRSchemaPropertySrc | OBJECT_OR_COLUMN |
| dbo | DPRSchemaAccess | AccessType | OBJECT_OR_COLUMN |
| dbo | QBM_YSingleGUID | TYPE |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1create function dbo.DPR_FTSchemaAccessChildren (@UID_Property1 varchar(38) , @UID_Property2 varchar(38) ) returns @erg table (UIDChild varchar(38) collate 2 database_default primary key ) with schemabinding as begin declare @Anzahl int declare @work dbo.QBM_YSingleGUID insert into @work(UID_SingleGuid) select 3 @UID_Property1 union select @UID_Property2 select @Anzahl = 1 while @Anzahl > 0 begin insert into @work(UID_SingleGuid) select distinct acc.UID_DPRSchemaPropertyTrg 4 from dbo.DPRSchemaAccess acc join @work ph on ph.UID_SingleGuid = acc.UID_DPRSchemaPropertySrc where acc.AccessType = 'Direct' and not exists (select 5 top 1 1 from @work e where e.UID_SingleGuid = acc.UID_DPRSchemaPropertyTrg ) select @Anzahl = @@ROWCOUNT end insert into @erg(UIDChild) select UID_SingleGuid 6 from @work endLabel: return end 7
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:16:47.173
None extracted.
Summary: writes INSERT into; reads/joins DPRSchemaAccess
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@UID_Property1 | varchar(38) | input |
@UID_Property2 | varchar(38) | input |
DML targets
INSERT intoCalled routines
None extracted.
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: @UID_Property1 @UID_Property2 @erg @Anzahl @work @ROWCOUNT
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.DPR_VWorkflowHandlesProperty | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.DPR_VWorkflowReadsProperty | SQL expression dependency | dbo · OBJECT_OR_COLUMN |