reference.RepoObject_ReferencingList - V

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

RepoObject_guid: E95BF6C2-0593-EB11-84F2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-reference.repoobject_referencinglist

Columns

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

nvarchar(max)

NULL

nvarchar(261)

NULL

nvarchar(257)

NULL

uniqueidentifier

NOT NULL

char(2)

NULL

Foreign Key Diagram

entity_1_1_fk-reference.repoobject_referencinglist

References

Object Reference Diagram - 1 1

entity_1_1_objectref-reference.repoobject_referencinglist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-reference.repoobject_referencinglist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-reference.repoobject_referencinglist

Column Reference Diagram

entity_1_1_colref-reference.repoobject_referencinglist

Indexes

idx_RepoObject_ReferencingList__1

Column Details

_

AntoraReferencingList

AntoraReferencingList

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

sql_modules_definition

reference.RepoObject_ReferencingList - V script
CREATE View reference.RepoObject_ReferencingList
As
Select
    ror.Referenced_guid
  , AntoraReferencingList =
  --
  String_Agg ( Cast(ror.referencing_AntoraXref As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                              ror.referencing_is_external
                                                                                                            , ror.referencing_fullname)
  , Referenced_fullname   = Max ( ror.referenced_fullname )
  , Referenced_fullname2  = Max ( ror.referenced_fullname2 )
  , Referenced_type       = Max ( ror.referenced_type )
From
    reference.RepoObject_ReferencedReferencing As ror
Where
    ror.referencing_is_DocsOutput = 1
Group By
    ror.Referenced_guid