property.RepoObjectColumnProperty_sys_repo - V

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

RepoObject_guid: 5590291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectcolumnproperty_sys_repo

Columns

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

1

uniqueidentifier

NOT NULL

2

sysname

NOT NULL

sql_variant

NULL

int

NULL

nvarchar(max)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectcolumnproperty_sys_repo

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectcolumnproperty_sys_repo

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectcolumnproperty_sys_repo

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectcolumnproperty_sys_repo

Column Reference Diagram

entity_1_1_colref-property.repoobjectcolumnproperty_sys_repo

Indexes

PK_RepoObjectColumnProperty_sys_repo

idx_RepoObjectColumnProperty_sys_repo__2

Column Details

_

RepoObjectColumn_guid

1

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

property_name

2

property_name

sysname

NOT NULL

property_value

property_value

sql_variant

NULL

RepoObjectColumnProperty_id

RepoObjectColumnProperty_id

int

NULL

RepoObjectColumnProperty_property_value

RepoObjectColumnProperty_property_value

nvarchar(max)

NULL

SysObject_name

SysObject_name

nvarchar(128)

NULL

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NULL

SysObjectColumn_name

SysObjectColumn_name

nvarchar(128)

NULL

sql_modules_definition

property.RepoObjectColumnProperty_sys_repo - V script
CREATE View property.RepoObjectColumnProperty_sys_repo
As
--
Select
    roc.RepoObjectColumn_guid
  , ses.property_name
  , ses.property_value
  , ses.SysObject_schema_name
  , ses.SysObject_name
  , SysObjectColumn_name                    = ses.entity_column_name
  , link.RepoObjectColumnProperty_id
  , RepoObjectColumnProperty_property_value = link.property_value
From
    repo_sys.ExtendedProperties           As ses
    Inner Join
        repo.RepoObject                   As ro
            On
            ses.SysObject_schema_name  = ro.SysObject_schema_name
            And ses.SysObject_name     = ro.SysObject_name

    Inner Join
        repo.RepoObjectColumn             As roc
            On
            ro.RepoObject_guid         = roc.RepoObject_guid
            And ses.entity_column_name = roc.SysObjectColumn_name
            And ses.property_name      <> 'RepoObjectColumn_guid'

    Left Join
        property.RepoObjectColumnProperty As link
            On
            roc.RepoObjectColumn_guid  = link.RepoObjectColumn_guid
            And ses.property_name      = link.property_name