dbo.TSB_FGIDPRNameSpaceFromRoot
SQL_SCALAR_FUNCTION
Created 2025-06-27T18:00:13.297 · modified 2026-04-14T23:19:13.503 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| varchar | yes |
@UID_Anchor | varchar | no |
@TableName | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| dbo | UNSAccountB | OBJECT_OR_COLUMN | |
| dbo | UNSAccountB | UID_UNSAccountB | OBJECT_OR_COLUMN |
| dbo | UNSAccountB | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSContainerB | OBJECT_OR_COLUMN | |
| dbo | UNSContainerB | UID_UNSContainerB | OBJECT_OR_COLUMN |
| dbo | UNSContainerB | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSGroupB | OBJECT_OR_COLUMN | |
| dbo | UNSGroupB | UID_UNSGroupB | OBJECT_OR_COLUMN |
| dbo | UNSGroupB | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSGroupB1 | OBJECT_OR_COLUMN | |
| dbo | UNSGroupB1 | UID_UNSGroupB1 | OBJECT_OR_COLUMN |
| dbo | UNSGroupB1 | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSGroupB2 | OBJECT_OR_COLUMN | |
| dbo | UNSGroupB2 | UID_UNSGroupB2 | OBJECT_OR_COLUMN |
| dbo | UNSGroupB2 | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSGroupB3 | OBJECT_OR_COLUMN | |
| dbo | UNSGroupB3 | UID_UNSGroupB3 | OBJECT_OR_COLUMN |
| dbo | UNSGroupB3 | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSItemB | OBJECT_OR_COLUMN | |
| dbo | UNSItemB | UID_UNSItemB | OBJECT_OR_COLUMN |
| dbo | UNSItemB | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSRootB | OBJECT_OR_COLUMN | |
| dbo | UNSRootB | UID_UNSRootB | OBJECT_OR_COLUMN |
| dbo | UNSRootB | UID_DPRNameSpace | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create function dbo.TSB_FGIDPRNameSpaceFromRoot(@UID_Anchor varchar(38) , @TableName varchar(30) ) returns varchar(38) with schemabinding as 2 begin declare @erg varchar(38) if @TableName = 'UnsAccountB' begin select top 1 @erg = y.UID_DPRNameSpace from dbo.UNSAccountB x join dbo.UNSRootB y on 3 x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSAccountB = @UID_Anchor return(@erg) end if @TableName = 'UnsRootB' begin select top 1 @erg = y.UID_DPRNameSpace 4 from dbo.UNSRootB y where y.UID_UNSRootB = @UID_Anchor return(@erg) end if @TableName = 'UNSContainerB' begin select top 1 @erg = y.UID_DPRNameSpace 5 from dbo.UNSContainerB x join dbo.UNSRootB y on x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSContainerB = @UID_Anchor return(@erg) end if @TableName 6 = 'UNSGroupB' begin select top 1 @erg = y.UID_DPRNameSpace from dbo.UNSGroupB x join dbo.UNSRootB y on x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSGroupB 7 = @UID_Anchor return(@erg) end if @TableName = 'UNSGroupB1' begin select top 1 @erg = y.UID_DPRNameSpace from dbo.UNSGroupB1 x join dbo.UNSRootB y on 8 x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSGroupB1 = @UID_Anchor return(@erg) end if @TableName = 'UNSGroupB2' begin select top 1 @erg = y.UID_DPRNameSpace 9 from dbo.UNSGroupB2 x join dbo.UNSRootB y on x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSGroupB2 = @UID_Anchor return(@erg) end if @TableName = 'UNSGroupB3' 10 begin select top 1 @erg = y.UID_DPRNameSpace from dbo.UNSGroupB3 x join dbo.UNSRootB y on x.UID_UNSRootB = y.UID_UNSRootB where x.UID_UNSGroupB3 = @UID_Anchor 11 return(@erg) end if @TableName = 'UNSItemB' begin select top 1 @erg = y.UID_DPRNameSpace from dbo.UNSItemB x join dbo.UNSRootB y on x.UID_UNSRootB = 12 y.UID_UNSRootB where x.UID_UNSItemB = @UID_Anchor return(@erg) end endLabel: return(@erg) end 13
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:19:13.503
None extracted.
Summary: reads/joins UNSAccountB, UNSRootB, UNSContainerB, UNSGroupB, UNSGroupB1…
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| varchar(38) | OUTPUT |
@UID_Anchor | varchar(38) | input |
@TableName | varchar(30) | input |
DML targets
None extracted.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: @UID_Anchor @TableName @erg
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.DepartmentHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ITShopOrgHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ITShopSrcHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.LocalityHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.OrgHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ProfitCenterHasUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSAccount | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSAccountHasUNSItem | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSAccountInUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSContainer | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSGroupCollection | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSGroupExclusion | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSGroupHasUnsItem | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSGroupInUNSGroup | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.UNSItem | SQL expression dependency | dbo · OBJECT_OR_COLUMN |