reference.RepoObject_ReferenceTree_30_0 - V

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

RepoObject_guid: D5E2805C-FDF5-EB11-850C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_referencetree_30_0

Columns

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

1

uniqueidentifier

NULL

2

uniqueidentifier

NULL

3

uniqueidentifier

NULL

int

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

char(2)

NULL

int

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_referencetree_30_0

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_referencetree_30_0

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_referencetree_30_0

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_referencetree_30_0

Column Reference Diagram

entity_1_1_colref-reference.repoobject_referencetree_30_0

Indexes

PK_RepoObject_ReferenceTree_30_0

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

Referencing_guid

2

Referencing_guid

uniqueidentifier

NULL

Referenced_guid

3

Referenced_guid

uniqueidentifier

NULL

Referenced_Depth

Referenced_Depth

int

NULL

Referenced_fullname

Referenced_fullname

nvarchar(261)

NULL

Referenced_fullname2

Referenced_fullname2

nvarchar(257)

NULL

Referenced_type

Referenced_type

char(2)

NULL

Referencing_Depth

Referencing_Depth

int

NULL

Referencing_fullname

Referencing_fullname

nvarchar(261)

NULL

Referencing_fullname2

Referencing_fullname2

nvarchar(257)

NULL

Referencing_type

Referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_ReferenceTree_30_0 - V script
CREATE View reference.RepoObject_ReferenceTree_30_0
As
Select
    tree.RepoObject_guid
  , tree.Referencing_guid
  , tree.Referenced_guid
  , Referencing_Depth     = Min ( tree.Referencing_Depth )
  , Referencing_fullname  = Max ( tree.Referencing_fullname )
  , Referencing_fullname2 = Max ( tree.Referencing_fullname2 )
  , Referencing_type      = Max ( tree.Referencing_type )
  , Referenced_Depth      = Min ( tree.Referenced_Depth )
  , Referenced_fullname   = Max ( tree.Referenced_fullname )
  , Referenced_fullname2  = Max ( tree.Referenced_fullname2 )
  , Referenced_type       = Max ( tree.Referenced_type )
From
    repo.RepoObject_gross                                                            As ro
    Cross Apply reference.ftv_RepoObject_ReferenceTree ( ro.RepoObject_guid, 30, 0 ) As tree
Where
    ro.is_in_reference = 1
Group By
    tree.RepoObject_guid
  , tree.Referencing_guid
  , tree.Referenced_guid