reference.RepoObject_ReferenceTree_referencing - V

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

RepoObject_guid: 66CDA946-459D-EB11-84F6-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_referencetree_referencing

Columns

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

1

uniqueidentifier

NULL

2

int

NULL

3

int

NULL

4

uniqueidentifier

NULL

5

uniqueidentifier

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

int

NULL

char(2)

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

int

NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_referencetree_referencing

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_referencetree_referencing

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_referencetree_referencing

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_referencetree_referencing

Column Reference Diagram

entity_1_1_colref-reference.repoobject_referencetree_referencing

Indexes

PK_RepoObject_ReferenceTree_referencing

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

Referenced_Depth

2

Referenced_Depth

int

NULL

Referencing_Depth

3

Referencing_Depth

int

NULL

Referenced_guid

4

Referenced_guid

uniqueidentifier

NULL

Referencing_guid

5

Referencing_guid

uniqueidentifier

NULL

Referenced_fullname

Referenced_fullname

nvarchar(261)

NULL

Referenced_fullname2

Referenced_fullname2

nvarchar(257)

NULL

referenced_is_DocsOutput

referenced_is_DocsOutput

int

NULL

Referenced_type

Referenced_type

char(2)

NULL

Referencing_fullname

Referencing_fullname

nvarchar(261)

NULL

Referencing_fullname2

Referencing_fullname2

nvarchar(257)

NULL

referencing_is_DocsOutput

referencing_is_DocsOutput

int

NULL

Referencing_type

Referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_ReferenceTree_referencing - V script
--bad performance
CREATE View reference.RepoObject_ReferenceTree_referencing
As
Select
    tree.referenced_fullname
  , tree.referenced_fullname2
  , tree.Referenced_guid
  , tree.referenced_is_DocsOutput
  , tree.referenced_type
  , tree.referencing_fullname
  , tree.referencing_fullname2
  , tree.Referencing_guid
  , tree.referencing_type
  , tree.referencing_is_DocsOutput
  , tree.Referenced_Depth
  , tree.Referencing_Depth
  , tree.RepoObject_guid
From
    repo.RepoObject_gross                                                                           As ro
    Cross Apply reference.ftv_RepoObject_ReferenceTree_referencing ( ro.RepoObject_guid, 100, 100 ) As tree
Where
    ro.is_in_reference = 1