reference.ReferenceTree_cyclic_union - V

type: V ( view ), modify_date: 2021-08-17 19:11:15

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

Description

Examples

Entity Diagram

entity-reference.referencetree_cyclic_union

Columns

Table 1. Columns of reference.ReferenceTree_cyclic_union - 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_union

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.referencetree_cyclic_union

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.referencetree_cyclic_union

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.referencetree_cyclic_union

Column Reference Diagram

entity_1_1_colref-reference.referencetree_cyclic_union

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_union - V script
CREATE View reference.ReferenceTree_cyclic_union
As
Select
    Referencing_guid
  , Referenced_guid
  , Referenced_fullname
  , Referenced_fullname2
  , Referenced_type
  , Referencing_fullname
  , Referencing_fullname2
  , Referencing_type
From
    reference.ReferenceTree_cyclic_ref_primary
Union
Select
    Referencing_guid
  , Referenced_guid
  , referenced_fullname
  , referenced_fullname2
  , referenced_type
  , referencing_fullname
  , referencing_fullname2
  , referencing_type
From
    reference.ReferenceTree_cyclic_ref_PersistenceUsp