dbo.DPR_FTSchemaPropertyAccessColl

SQL_TABLE_VALUED_FUNCTION

Created 2026-04-14T23:16:47.140 · modified 2026-04-14T23:16:47.140 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
No parameters.

Referenced objects

SchemaObjectColumn/minorClass
dboDPRSchemaAccessOBJECT_OR_COLUMN
dboDPRSchemaAccessUID_DPRSchemaPropertyTrgOBJECT_OR_COLUMN
dboDPRSchemaAccessUID_DPRSchemaPropertySrcOBJECT_OR_COLUMN
dboDPRSchemaAccessAccessTypeOBJECT_OR_COLUMN
dboDPRSchemaAccessObjectKeyAccessorOBJECT_OR_COLUMN
dboQBM_YParameterListTYPE

Source excerpt

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

Open full formatted source

1create function dbo.DPR_FTSchemaPropertyAccessColl () returns @erg table (UID_DPRSchemaPropertySrc varchar(38) collate database_default  , UID_DPRSchemaPropertyTrg
2 varchar(38) collate database_default  , ObjectKeyAccessor varchar(138) collate database_default  ) with schemabinding as begin declare @lauf int declare
3 @work dbo.QBM_YParameterList insert into @work (Parameter1 , Parameter2 , Parameter3 ) select UID_DPRSchemaPropertySrc, UID_DPRSchemaPropertyTrg, ObjectKeyAccessor
4 from dbo.DPRSchemaAccess where AccessType = 'Direct' select @lauf = 1 while @lauf > 0 begin insert into @work (Parameter1  , Parameter2 , Parameter3 )
5 select distinct e.Parameter1  , dpr.UID_DPRSchemaPropertyTrg, dpr.ObjectKeyAccessor from @work e join dbo.DPRSchemaAccess dpr on e.Parameter2  = dpr.UID_DPRSchemaPropertySrc
6 where Not exists (select top 1 1 from @work b where b.Parameter1  = e.Parameter1  and b.Parameter2  = dpr.UID_DPRSchemaPropertyTrg ) and dpr.AccessType
7 = 'Direct' select @lauf = @@rowcount end  insert into @erg (UID_DPRSchemaPropertySrc, UID_DPRSchemaPropertyTrg, ObjectKeyAccessor) select w.Parameter1
8, w.Parameter2, w.Parameter3 from @work w return end 
9

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.140

None extracted.

Summary: writes INSERT into; reads/joins DPRSchemaAccess

Declared parameters

No declared parameters in sys.parameters for this object, or metadata was not available.

DML targets

INSERT into

Called 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: @erg @lauf @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.

No reverse dependencies extracted.