reference.ReferenceTree_cyclic_ref_primary - V

type: V ( view ), modify_date: 2021-08-17 19:10:43

RepoObject_guid: 81E72F09-C5FD-EB11-850F-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.referencetree_cyclic_ref_primary

Columns

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

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

char(2)

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

varchar(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.referencetree_cyclic_ref_primary

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.referencetree_cyclic_ref_primary

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.referencetree_cyclic_ref_primary

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.referencetree_cyclic_ref_primary

Column Reference Diagram

entity_1_1_colref-reference.referencetree_cyclic_ref_primary

Indexes

idx_ReferenceTree_cyclic_ref_primary__1

Column Details

_

Referenced_fullname

Referenced_fullname

nvarchar(261)

NULL

Referenced_fullname2

Referenced_fullname2

nvarchar(257)

NULL

Referenced_guid

Referenced_guid

uniqueidentifier

NOT NULL

Referenced_type

Referenced_type

char(2)

NULL

Referencing_fullname

Referencing_fullname

nvarchar(261)

NULL

Referencing_fullname2

Referencing_fullname2

nvarchar(257)

NULL

Referencing_guid

Referencing_guid

uniqueidentifier

NOT NULL

Referencing_type

Referencing_type

varchar(2)

NULL

sql_modules_definition

reference.ReferenceTree_cyclic_ref_primary - V script
CREATE View reference.ReferenceTree_cyclic_ref_primary
As
Select
    Distinct
    Referencing_guid
  , Referenced_guid
  , Referenced_fullname
  , Referenced_fullname2
  , Referenced_type
  , Referencing_fullname
  , Referencing_fullname2
  , Referencing_type
From
    reference.RepoObject_ReferenceTree_cyclic