reference.RepoObjectColumn_ReferencedList - V

type: V ( view ), modify_date: 2022-09-08 16:33:45

RepoObject_guid: B635B4CD-E093-EB11-84F2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobjectcolumn_referencedlist

Columns

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

nvarchar(max)

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

char(2)

NULL

nvarchar(392)

NULL

nvarchar(386)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobjectcolumn_referencedlist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_referencedlist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_referencedlist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_referencedlist

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_referencedlist

Indexes

idx_RepoObjectColumn_ReferencedList__1

Column Details

_

AntoraReferencedColumnList

AntoraReferencedColumnList

nvarchar(max)

NULL

Referencing_fullname

Referencing_fullname

nvarchar(261)

NULL

Description

(concat('[',[referencing_schema_name],'].[',[referencing_entity_name],']'))


Referencing_fullname2

Referencing_fullname2

nvarchar(257)

NULL

Referencing_guid

Referencing_guid

uniqueidentifier

NOT NULL

Referencing_type

Referencing_type

char(2)

NULL

ReferencingColumn_fullname

ReferencingColumn_fullname

nvarchar(392)

NULL

ReferencingColumn_fullname2

ReferencingColumn_fullname2

nvarchar(386)

NULL

sql_modules_definition

reference.RepoObjectColumn_ReferencedList - V script
CREATE View reference.RepoObjectColumn_ReferencedList
As
Select
    ror.Referencing_guid
  , AntoraReferencedColumnList  =
  --
  String_Agg ( Cast(ror.referenced_AntoraXref As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                             ror.Referenced_fullname)
  , Referencing_fullname        = Max ( ror.Referencing_fullname )
  , Referencing_fullname2       = Max ( ror.Referencing_fullname2 )
  , ReferencingColumn_fullname  = Max ( ror.ReferencingColumn_fullname )
  , ReferencingColumn_fullname2 = Max ( ror.ReferencingColumn_fullname2 )
  , Referencing_type            = Max ( ror.Referencing_type )
From
    reference.RepoObjectColumn_ReferencedReferencing As ror
Group By
    ror.Referencing_guid