reference.RepoObjectColumn_reference - V

type: V ( view ), modify_date: 2022-01-05 18:06:35

RepoObject_guid: 2CD81BF9-57F5-EB11-850C-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobjectcolumn_reference

Columns

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

1

uniqueidentifier

NULL

2

uniqueidentifier

NULL

tinyint

NULL

tinyint

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

tinyint

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

tinyint

NULL

uniqueidentifier

NULL

nvarchar(128)

NULL

char(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectcolumn_reference

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_reference

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_reference

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_reference

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_reference

Indexes

PK_RepoObjectColumn_reference

Column Details

_

referenced_RepoObjectColumn_guid

1

referenced_RepoObjectColumn_guid

uniqueidentifier

NULL

referencing_RepoObjectColumn_guid

2

referencing_RepoObjectColumn_guid

uniqueidentifier

NULL

is_referenced_object

is_referenced_object

tinyint

NULL

is_referencing_object_equal_referenced_object

is_referencing_object_equal_referenced_object

tinyint

NULL

referenced_column_name

referenced_column_name

nvarchar(128)

NULL

referenced_entity_name

referenced_entity_name

nvarchar(128)

NULL

referenced_external_AntoraComponent

referenced_external_AntoraComponent

nvarchar(128)

NULL

referenced_external_AntoraModule

referenced_external_AntoraModule

nvarchar(128)

NULL

referenced_is_external

referenced_is_external

tinyint

NULL

referenced_RepoObject_guid

referenced_RepoObject_guid

uniqueidentifier

NULL

referenced_schema_name

referenced_schema_name

nvarchar(128)

NULL

referenced_type

referenced_type

char(2)

NULL

referencing_column_name

referencing_column_name

nvarchar(128)

NULL

referencing_entity_name

referencing_entity_name

nvarchar(128)

NULL

referencing_external_AntoraComponent

referencing_external_AntoraComponent

nvarchar(128)

NULL

referencing_external_AntoraModule

referencing_external_AntoraModule

nvarchar(128)

NULL

referencing_is_external

referencing_is_external

tinyint

NULL

referencing_RepoObject_guid

referencing_RepoObject_guid

uniqueidentifier

NULL

referencing_schema_name

referencing_schema_name

nvarchar(128)

NULL

referencing_type

referencing_type

char(2)

NULL

sql_modules_definition

reference.RepoObjectColumn_reference - V script
CREATE View reference.RepoObjectColumn_reference
As
Select
    referenced_RepoObjectColumn_guid
  , referencing_RepoObjectColumn_guid
  , referenced_RepoObject_guid                    = Max ( referenced_RepoObject_guid )
  , referenced_schema_name                        = Max ( referenced_schema_name )
  , referenced_entity_name                        = Max ( referenced_entity_name )
  , referenced_column_name                        = Max ( referenced_column_name )
  , referenced_type                               = Max ( referenced_type )
  , referenced_external_AntoraComponent           = Max ( referenced_external_AntoraComponent )
  , referenced_external_AntoraModule              = Max ( referenced_external_AntoraModule )
  , referenced_is_external                        = Max ( IsNull ( referenced_is_external, 0 ))
  , referencing_RepoObject_guid                   = Max ( referencing_RepoObject_guid )
  , referencing_schema_name                       = Max ( referencing_schema_name )
  , referencing_entity_name                       = Max ( referencing_entity_name )
  , referencing_column_name                       = Max ( referencing_column_name )
  , referencing_type                              = Max ( referencing_type )
  , referencing_external_AntoraComponent          = Max ( referencing_external_AntoraComponent )
  , referencing_external_AntoraModule             = Max ( referencing_external_AntoraModule )
  , referencing_is_external                       = Max ( IsNull ( referencing_is_external, 0 ))
  , is_referencing_object_equal_referenced_object = Max ( Cast(is_referencing_object_equal_referenced_object As TinyInt))
  , is_referenced_object                          = Max ( Cast(is_referenced_object As TinyInt))
From
    reference.RepoObjectColumn_reference_union
Group By
    referenced_RepoObjectColumn_guid
  , referencing_RepoObjectColumn_guid
Having
    ( Not ( referenced_RepoObjectColumn_guid Is Null ))
    And ( Not ( referencing_RepoObjectColumn_guid Is Null ))