reference.additional_Reference_from_properties_src - V

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

RepoObject_guid: 48EFD408-A51F-EC11-8523-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.additional_reference_from_properties_src

Columns

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

1

nvarchar(max)

NULL

2

nvarchar(max)

NULL

3

nvarchar(max)

NULL

4

nvarchar(max)

NULL

5

nvarchar(max)

NULL

6

nvarchar(max)

NULL

7

nvarchar(max)

NULL

8

nvarchar(max)

NULL

9

nvarchar(max)

NULL

10

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.additional_reference_from_properties_src

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.additional_reference_from_properties_src

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.additional_reference_from_properties_src

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.additional_reference_from_properties_src

Column Reference Diagram

entity_1_1_colref-reference.additional_reference_from_properties_src

Indexes

PK_additional_Reference_from_properties_src

Column Details

_

referenced_AntoraComponent

1

referenced_AntoraComponent

nvarchar(max)

NULL

referenced_AntoraModule

2

referenced_AntoraModule

nvarchar(max)

NULL

referenced_Schema

3

referenced_Schema

nvarchar(max)

NULL

referenced_Object

4

referenced_Object

nvarchar(max)

NULL

referenced_Column

5

referenced_Column

nvarchar(max)

NULL

referencing_AntoraComponent

6

referencing_AntoraComponent

nvarchar(max)

NULL

referencing_AntoraModule

7

referencing_AntoraModule

nvarchar(max)

NULL

referencing_Schema

8

referencing_Schema

nvarchar(max)

NULL

referencing_Object

9

referencing_Object

nvarchar(max)

NULL

referencing_Column

10

referencing_Column

nvarchar(max)

NULL

sql_modules_definition

reference.additional_Reference_from_properties_src - V script
CREATE View reference.additional_Reference_from_properties_src
As
Select
    Distinct
    referenced_AntoraComponent  = pvt.[1]
  , referenced_AntoraModule     = pvt.[2]
  , referenced_Schema           = pvt.[3]
  , referenced_Object           = pvt.[4]
  , referenced_Column           = pvt.[5]
  , referencing_AntoraComponent = pvt.[6]
  , referencing_AntoraModule    = pvt.[7]
  , referencing_Schema          = pvt.[8]
  , referencing_Object          = pvt.[9]
  , referencing_Column          = pvt.[10]
From
(
    Select
        RepoObject_guid
      , property_name
      , LinePerGuidProperty
      --, property_value
      --, value_line
      --, value_line_len
      , value_line_row
      , RowPerGuidPropertyLine
    From
        property.RepoObjectProperty_SelectedPropertyName_split
) As tbl
Pivot
(
    Max(value_line_row)
    For RowPerGuidPropertyLine In
    ( [1], [2], [3], [4], [5], [6], [7], [8], [9], [10] )
) As pvt
Where
    property_name = 'additional_reference_csv'
    And pvt.[5]   <> 'null'
    And pvt.[5]   <> ''
    And pvt.[10]  <> 'null'
    And pvt.[10]  <> ''