reference.RepoObjectColumn_ReferencingList - V

type: V ( view ), modify_date: 2022-09-08 16:34:18

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

Description

Examples

Entity Diagram

entity-reference.repoobjectcolumn_referencinglist

Columns

Table 1. Columns of reference.RepoObjectColumn_ReferencingList - 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_referencinglist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobjectcolumn_referencinglist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobjectcolumn_referencinglist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobjectcolumn_referencinglist

Column Reference Diagram

entity_1_1_colref-reference.repoobjectcolumn_referencinglist

Indexes

idx_RepoObjectColumn_ReferencingList__1

Column Details

_

AntoraReferencingColumnList

AntoraReferencingColumnList

nvarchar(max)

NULL

Referenced_fullname

Referenced_fullname

nvarchar(261)

NULL

Description

(concat('[',[referenced_schema_name],'].[',[referenced_entity_name],']'))


Referenced_fullname2

Referenced_fullname2

nvarchar(257)

NULL

Referenced_guid

Referenced_guid

uniqueidentifier

NOT NULL

Referenced_type

Referenced_type

char(2)

NULL

ReferencedColumn_fullname

ReferencedColumn_fullname

nvarchar(392)

NULL

ReferencedColumn_fullname2

ReferencedColumn_fullname2

nvarchar(386)

NULL

sql_modules_definition

reference.RepoObjectColumn_ReferencingList - V script
CREATE View reference.RepoObjectColumn_ReferencingList
As
Select
    ror.Referenced_guid
  , AntoraReferencingColumnList =
  --
  String_Agg ( Cast(ror.referencing_AntoraXref As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                              ror.Referencing_fullname)
  , Referenced_fullname         = Max ( ror.Referenced_fullname )
  , Referenced_fullname2        = Max ( ror.Referenced_fullname2 )
  , ReferencedColumn_fullname   = Max ( ror.ReferencedColumn_fullname )
  , ReferencedColumn_fullname2  = Max ( ror.ReferencedColumn_fullname2 )
  , Referenced_type             = Max ( ror.Referenced_type )
From
    reference.RepoObjectColumn_ReferencedReferencing As ror
Group By
    ror.Referenced_guid