reference.Persistence_bidirectional - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

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

Description

Examples

Entity Diagram

entity-reference.persistence_bidirectional

Columns

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

nvarchar(261)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

nvarchar(140)

NULL

uniqueidentifier

NULL

nvarchar(261)

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

nvarchar(140)

NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-reference.persistence_bidirectional

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.persistence_bidirectional

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.persistence_bidirectional

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.persistence_bidirectional

Column Reference Diagram

entity_1_1_colref-reference.persistence_bidirectional

Indexes

idx_Persistence_bidirectional__1

idx_Persistence_bidirectional__2

idx_Persistence_bidirectional__3

idx_Persistence_bidirectional__4

idx_Persistence_bidirectional__5

idx_Persistence_bidirectional__6

Column Details

_

referenced_fullname

referenced_fullname

nvarchar(261)

NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_usp_persistence_name

referenced_usp_persistence_name

nvarchar(140)

NULL

Description

('usp_PERSIST_'+[RepoObject_name])


referenced_usp_persistence_RepoObject_guid

referenced_usp_persistence_RepoObject_guid

uniqueidentifier

NULL

referencing_fullname

referencing_fullname

nvarchar(261)

NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL

referencing_usp_persistence_name

referencing_usp_persistence_name

nvarchar(140)

NULL

Description

('usp_PERSIST_'+[RepoObject_name])


referencing_usp_persistence_RepoObject_guid

referencing_usp_persistence_RepoObject_guid

uniqueidentifier

NULL

sql_modules_definition

reference.Persistence_bidirectional - V script
/*
check for bidirectional references +
They case errors in SSIS or defining the order for linear procedure call and needs to be eleminated
*/
CREATE View reference.Persistence_bidirectional
As
Select
    T1.referenced_RepoObject_guid
  , T1.referenced_fullname
  , T1.referenced_schema_name
  , T1.referenced_usp_persistence_name
  , T1.referenced_usp_persistence_RepoObject_guid
  , T1.referencing_RepoObject_guid
  , T1.referencing_fullname
  , T1.referencing_schema_name
  , T1.referencing_usp_persistence_name
  , T1.referencing_usp_persistence_RepoObject_guid
From
    reference.Persistence     As T1
    Inner Join
        reference.Persistence As T2
            On
            T1.referenced_RepoObject_guid      = T2.referencing_RepoObject_guid
            And T1.referencing_RepoObject_guid = T2.referenced_RepoObject_guid