reference.RepoObject_ReferencedList - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of reference.RepoObject_ReferencedList - V
Column Name	Data Type	NULL?
AntoraReferencedList	`nvarchar(max)`	`NULL`
Referencing_fullname	`nvarchar(261)`	`NULL`
Referencing_fullname2	`nvarchar(257)`	`NULL`
Referencing_guid	`uniqueidentifier`	`NOT NULL`
Referencing_type	`varchar(2)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

reference.RepoObject_ReferencedReferencing - V

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_RepoObject_ReferencedList__1

IndexSemanticGroup: no_group
- [column-Referencing_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

Column Details

_

AntoraReferencedList

nvarchar(max)

NULL

Referencing Columns

Referencing_fullname

nvarchar(261)

NULL

Description

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

Referenced Columns

reference.RepoObject_ReferencedReferencing.referencing_fullname

Referencing_fullname2

nvarchar(257)

NULL

Referencing_guid

uniqueidentifier

NOT NULL

Referenced Columns

reference.RepoObject_ReferencedReferencing.Referencing_guid

Referencing_type

varchar(2)

NULL

sql_modules_definition

reference.RepoObject_ReferencedList - V script

CREATE View reference.RepoObject_ReferencedList
As
Select
    ror.Referencing_guid
  , AntoraReferencedList  =
  --
  String_Agg ( Cast(ror.referenced_AntoraXref As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                             ror.referenced_is_external
                                                                                                           , ror.referenced_fullname)
  , Referencing_fullname  = Max ( ror.referencing_fullname )
  , Referencing_fullname2 = Max ( ror.referencing_fullname2 )
  , Referencing_type      = Max ( ror.referencing_type )
From
    reference.RepoObject_ReferencedReferencing As ror
Where
    ror.referenced_is_DocsOutput = 1
Group By
    ror.Referencing_guid