docs.ObjectRefCyclic_ObjectRefList - V

type: V ( view ), modify_date: 2021-08-28 23:21:20

RepoObject_guid: 85E72F09-C5FD-EB11-850F-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.objectrefcyclic_objectreflist

Columns

Table 1. Columns of docs.ObjectRefCyclic_ObjectRefList - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.objectrefcyclic_objectreflist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.objectrefcyclic_objectreflist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.objectrefcyclic_objectreflist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.objectrefcyclic_objectreflist

Column Reference Diagram

entity_1_1_colref-docs.objectrefcyclic_objectreflist

Column Details

_

PumlObjectRefList

PumlObjectRefList

nvarchar(max)

NULL

sql_modules_definition

docs.ObjectRefCyclic_ObjectRefList - V script
CREATE View docs.ObjectRefCyclic_ObjectRefList
As
Select
    PumlObjectRefList =
    --
    String_Agg (
                   Concat (
                              Cast(N'' As NVarchar(Max))
                            , docs.fs_cleanStringForPuml ( objectref.Referenced_fullname2 )
                            , ' <.. '
                            , docs.fs_cleanStringForPuml ( objectref.Referencing_fullname2 )
                          )
                 , Char ( 13 ) + Char ( 10 )
               ) Within Group(Order By
                                  objectref.Referenced_fullname2)
From
    reference.ReferenceTree_cyclic_union As objectref