repo.RepoObject_sat2 - V

type: V ( view ), modify_date: 2022-01-05 18:06:34

RepoObject_guid: A385AF41-F924-EC11-8527-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject_sat2

Columns

Table 1. Columns of repo.RepoObject_sat2 - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.repoobject_sat2

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject_sat2

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject_sat2

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject_sat2

Column Reference Diagram

entity_1_1_colref-repo.repoobject_sat2

Indexes

PK_RepoObject_sat2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

AntoraReferencedList

AntoraReferencedList

nvarchar(max)

NULL

AntoraReferencingList

AntoraReferencingList

nvarchar(max)

NULL

CreateColumnList

CreateColumnList

nvarchar(max)

NULL

DbmlColumnList

DbmlColumnList

nvarchar(max)

NULL

PersistenceCompareColumnList

PersistenceCompareColumnList

nvarchar(max)

NULL

PersistenceInsertColumnList

PersistenceInsertColumnList

nvarchar(max)

NULL

PersistenceUpdateColumnList

PersistenceUpdateColumnList

nvarchar(max)

NULL

sql_modules_antora

sql_modules_antora

nvarchar(max)

NULL

sql_modules_definition

sql_modules_definition

nvarchar(max)

NULL

sql_modules_formatted

sql_modules_formatted

nvarchar(max)

NULL

sql_modules_formatted2

sql_modules_formatted2

nvarchar(max)

NULL

sql_modules_definition

repo.RepoObject_sat2 - V script
Create View repo.RepoObject_sat2
As
Select
    ro.RepoObject_guid
  , ColumnList.CreateColumnList
  , ColumnList.DbmlColumnList
  , ColumnList.PersistenceCompareColumnList
  , ColumnList.PersistenceInsertColumnList
  , ColumnList.PersistenceUpdateColumnList
  , SqlModules.sql_modules_definition
  , sql_modules_antora = Replace (
                                     Replace (
                                                 Replace ( SqlModules.sql_modules_definition, '\include::', '\\include::' )
                                               , '\ifdef::'
                                               , '\\ifdef::'
                                             )
                                   , '\endif::'
                                   , '\\endif::'
                                 )
  , SqlModules.sql_modules_formatted
  , SqlModules.sql_modules_formatted2
  , ro_referenced.AntoraReferencedList
  , ro_referencing.AntoraReferencingList
--, ext_referenced.AntoraExternalReferencedList
--, ext_referencing.AntoraExternalReferencingList
--, AntoraModule       = AntoraModule.Parameter_value_result
--, AntoraComponent    = AntoraComponent.Parameter_value_result
From
    repo.RepoObject_gross                       As ro
    Left Outer Join
        repo.RepoObject_ColumnList              As ColumnList
            On
            ColumnList.RepoObject_guid     = ro.RepoObject_guid

    Left Outer Join
        sqlparse.RepoObject_SqlModules_Repo_Sys As SqlModules
            On
            SqlModules.RepoObject_guid     = ro.RepoObject_guid

    Left Join
        reference.RepoObject_ReferencedList     As ro_referenced
            On
            ro_referenced.Referencing_guid = ro.RepoObject_guid

    Left Join
        reference.RepoObject_ReferencingList    As ro_referencing
            On
            ro_referencing.Referenced_guid = ro.RepoObject_guid