property.RepoObjectProperty_ForUpdate - V

type: V ( view ), modify_date: 2021-09-22 20:01:46

RepoObject_guid: 647159E3-27E6-EB11-8507-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectproperty_forupdate

Columns

Table 1. Columns of property.RepoObjectProperty_ForUpdate - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

tinyint

NULL

nvarchar(128)

NOT NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NOT NULL

int

NOT NULL

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectproperty_forupdate

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectproperty_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectproperty_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectproperty_forupdate

Column Reference Diagram

entity_1_1_colref-property.repoobjectproperty_forupdate

Indexes

idx_RepoObjectProperty_ForUpdate__1

idx_RepoObjectProperty_ForUpdate__2

idx_RepoObjectProperty_ForUpdate__3

Column Details

_

AntoraComponent

AntoraComponent

nvarchar(max)

NULL

AntoraModule

AntoraModule

nvarchar(max)

NULL

dwh_database

dwh_database

nvarchar(128)

NULL

inheritance

inheritance

tinyint

NULL

property_name

property_name

nvarchar(128)

NOT NULL

property_value

property_value

nvarchar(max)

NULL

repo_database

repo_database

nvarchar(128)

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([RepoObject_schema_name],'.',[RepoObject_name]))


RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_name

RepoObject_name

nvarchar(128)

NOT NULL

Referenced Columns

RepoObject_schema_name

RepoObject_schema_name

nvarchar(128)

NOT NULL

RepoObject_type

RepoObject_type

char(2)

NOT NULL

Referenced Columns

RepoObjectProperty_id

RepoObjectProperty_id

int

NOT NULL

tsql_comment_tag

tsql_comment_tag

nvarchar(max)

NOT NULL

sql_modules_definition

property.RepoObjectProperty_ForUpdate - V script
CREATE View property.RepoObjectProperty_ForUpdate
As
Select
    T1.RepoObjectProperty_id
  , T1.RepoObject_guid
  , T1.property_name
  , T1.property_value
  , T1.inheritance
  --,T1.[property_basetype]
  --,T1.[property_int]
  --,T1.[property_bigint]
  --,T1.[property_varchar]
  --,T1.[property_nvarchar]
  --,T1.[property_real]
  --,T1.[property_float]
  --,T1.[property_money]
  , T2.RepoObject_fullname
  , T2.RepoObject_fullname2
  , T2.RepoObject_schema_name
  , T2.RepoObject_name
  , T2.RepoObject_type
  , tsql_comment_tag = Concat (
                                  '<<property_start>>' + T1.property_name
                                , Char ( 13 ) + Char ( 10 )
                                , Replace ( T1.property_value, '''', '''''' )
                                , Char ( 13 ) + Char ( 10 )
                                , '<<property_end>>'
                                , Char ( 13 ) + Char ( 10 )
                              )
  , repo_database    = Db_Name ()
  , dwh_database     = config.fs_dwh_database_name ()
  , AntoraComponent  = config.fs_get_parameter_value ( 'AntoraComponent', '' )
  , AntoraModule     = config.fs_get_parameter_value ( 'AntoraModule', '' )
From
    property.RepoObjectProperty As T1
    Inner Join
        repo.RepoObject         As T2
            On
            T2.RepoObject_guid = T1.RepoObject_guid