reference.additional_Reference_database - V

type: V ( view ), modify_date: 2021-09-22 08:02:58

RepoObject_guid: C8B17B93-D017-EC11-851C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_database

Columns

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

1

AntoraComponent

nvarchar(128)

NOT NULL

2

AntoraModule

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference_database

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_database

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_database

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_database

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_database

Indexes

PK_additional_Reference_database

Column Details

_

AntoraComponent

1

AntoraComponent

nvarchar(128)

NOT NULL
Referencing Columns

AntoraModule

2

AntoraModule

nvarchar(128)

NOT NULL
Referencing Columns

sql_modules_definition

reference.additional_Reference_database - V script 
CREATE View reference.additional_Reference_database
As
Select
    AntoraComponent = referenced_AntoraComponent
  , AntoraModule    = referenced_AntoraModule
From
    reference.additional_Reference_is_external
--only external with any connenction to internal RepoObject
Where
    referenced_is_external      = 1
    And referencing_is_external = 0
Union
Select
    AntoraComponent = referencing_AntoraComponent
  , AntoraModule    = referencing_AntoraModule
From
    reference.additional_Reference_is_external
--only external with any connenction to internal RepoObject
Where
    referenced_is_external      = 0
    And referencing_is_external = 1