docs.Schema_PumlPartial_FkRefList - V

type: V ( view ), modify_date: 2021-11-07 10:39:52

RepoObject_guid: 0A60D8EE-E90A-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.schema_pumlpartial_fkreflist

Columns

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

nvarchar(10)

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.schema_pumlpartial_fkreflist

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.schema_pumlpartial_fkreflist

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.schema_pumlpartial_fkreflist

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.schema_pumlpartial_fkreflist

Column Reference Diagram

entity_1_1_colref-docs.schema_pumlpartial_fkreflist

Column Details

_

cultures_name

cultures_name

nvarchar(10)

NULL

PumlPartial_FkRefList

PumlPartial_FkRefList

nvarchar(max)

NULL

SchemaName

SchemaName

nvarchar(128)

NULL

sql_modules_definition

docs.Schema_PumlPartial_FkRefList - V script
CREATE View docs.Schema_PumlPartial_FkRefList
As
Select
    SchemaName    = fk.referencing_SysObject_schema_name
  , cultures_name = Cast('' As NVarchar(10))
  , PumlPartial_FkRefList     = String_Agg (
                                   Concat (
                                              Cast(N'' As NVarchar(Max))
                                            , docs.fs_cleanStringForPuml ( fk.referenced_RepoObject_fullname2 )
                                            , '::'
                                            , docs.fs_cleanStringForPuml ( fk.referenced_index_name )
                                            , ' <-- '
                                            , docs.fs_cleanStringForPuml ( fk.referencing_RepoObject_fullname2 )
                                            , '::'
                                            , docs.fs_cleanStringForPuml ( fk.referencing_index_name )
                                          )
                                 , Char ( 13 ) + Char ( 10 )
                               ) Within Group(Order By
                                                  fk.referenced_RepoObject_fullname2
                                                , fk.referencing_RepoObject_fullname2)
From
    repo.ForeignKey_Indexes_union_T As fk
Where
    fk.referenced_SysObject_schema_name = fk.referencing_SysObject_schema_name
Group By
    fk.referencing_SysObject_schema_name