reference.RepoObjectColumn_ReferenceTree - V

type: V ( view ), modify_date: 2022-01-05 18:06:33

RepoObject_guid: 404679B8-147C-EB11-84E6-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobjectcolumn_referencetree

Columns

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

int

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

char(2)

NULL

nvarchar(392)

NULL

nvarchar(386)

NULL

nvarchar(128)

NULL

int

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

char(2)

NULL

nvarchar(392)

NULL

nvarchar(386)

NULL

nvarchar(128)

NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectcolumn_referencetree

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_referencetree

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_referencetree

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_referencetree

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_referencetree

Column Details

_

Referenced_Depth

Referenced_Depth

int

NULL

Referenced_fullname

Referenced_fullname

nvarchar(261)

NULL

Referenced_fullname2

Referenced_fullname2

nvarchar(257)

NULL

Referenced_guid

Referenced_guid

uniqueidentifier

NULL

Referenced_RepoObject_guid

Referenced_RepoObject_guid

uniqueidentifier

NULL

Referenced_type

Referenced_type

char(2)

NULL

ReferencedColumn_fullname

ReferencedColumn_fullname

nvarchar(392)

NULL

ReferencedColumn_fullname2

ReferencedColumn_fullname2

nvarchar(386)

NULL

ReferencedColumn_name

ReferencedColumn_name

nvarchar(128)

NULL

Referencing_Depth

Referencing_Depth

int

NULL

Referencing_fullname

Referencing_fullname

nvarchar(261)

NULL

Referencing_fullname2

Referencing_fullname2

nvarchar(257)

NULL

Referencing_guid

Referencing_guid

uniqueidentifier

NULL

Referencing_RepoObject_guid

Referencing_RepoObject_guid

uniqueidentifier

NULL

Referencing_type

Referencing_type

char(2)

NULL

ReferencingColumn_fullname

ReferencingColumn_fullname

nvarchar(392)

NULL

ReferencingColumn_fullname2

ReferencingColumn_fullname2

nvarchar(386)

NULL

ReferencingColumn_name

ReferencingColumn_name

nvarchar(128)

NULL

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NULL

sql_modules_definition

reference.RepoObjectColumn_ReferenceTree - V script
--Attention with *, if the source changes!
CREATE View reference.RepoObjectColumn_ReferenceTree
As
Select
    tree.*
From
    repo.RepoObjectColumn                                                                              As roc
    Cross Apply reference.ftv_RepoObjectColumn_ReferenceTree ( roc.RepoObjectColumn_guid, 1000, 1000 ) As tree