reference.RepoObject_ReferenceTree_referencing_0_30 - V

type: V ( view ), modify_date: 2021-12-16 11:41:19

RepoObject_guid: DBC7D500-ECF5-EB11-850C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_referencetree_referencing_0_30

Columns

Table 1. Columns of reference.RepoObject_ReferenceTree_referencing_0_30 - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

uniqueidentifier

NULL

int

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_referencetree_referencing_0_30

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_referencetree_referencing_0_30

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_referencetree_referencing_0_30

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_referencetree_referencing_0_30

Column Reference Diagram

entity_1_1_colref-reference.repoobject_referencetree_referencing_0_30

Indexes

PK_RepoObject_ReferenceTree_referencing_0_30

idx_RepoObject_ReferenceTree_referencing_0_30__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

Referencing_guid

2

Referencing_guid

uniqueidentifier

NULL

referencing_Depth

referencing_Depth

int

NULL

referencing_fullname

referencing_fullname

nvarchar(261)

NULL

referencing_fullname2

referencing_fullname2

nvarchar(257)

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NULL

sql_modules_definition

reference.RepoObject_ReferenceTree_referencing_0_30 - V script
CREATE View reference.RepoObject_ReferenceTree_referencing_0_30
As
Select
    ro.RepoObject_guid
  , tree.Referencing_guid
  , RepoObject_fullname   = Max ( ro.RepoObject_fullname )
  , RepoObject_fullname2  = Max ( ro.RepoObject_fullname2 )
  , referencing_fullname  = Max ( tree.Referencing_fullname )
  , referencing_fullname2 = Max ( tree.Referencing_fullname2 )
  , referencing_Depth     = Min ( tree.Referencing_Depth )
From
    repo.RepoObject_gross                                                                        As ro
    Cross Apply reference.ftv_RepoObject_ReferenceTree_referencing ( ro.RepoObject_guid, 0, 30 ) As tree
Where
    ro.is_in_reference = 1
Group By
    ro.RepoObject_guid
  , tree.Referencing_guid