property.RepoObjectProperty_sys_repo - V

type: V ( view ), modify_date: 2021-08-17 19:05:41

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

Description

Examples

Entity Diagram

entity-property.repoobjectproperty_sys_repo

Columns

Table 1. Columns of property.RepoObjectProperty_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

Foreign Key Diagram

entity_1_1_fk-property.repoobjectproperty_sys_repo

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectproperty_sys_repo

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectproperty_sys_repo

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectproperty_sys_repo

Column Reference Diagram

entity_1_1_colref-property.repoobjectproperty_sys_repo

Indexes

PK_RepoObjectProperty_sys_repo

idx_RepoObjectProperty_sys_repo__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

property_name

2

property_name

sysname

NOT NULL

property_value

property_value

sql_variant

NULL

RepoObjectProperty_id

RepoObjectProperty_id

int

NULL

RepoObjectProperty_property_value

RepoObjectProperty_property_value

nvarchar(max)

NULL

SysObject_name

SysObject_name

nvarchar(128)

NULL

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NULL

sql_modules_definition

property.RepoObjectProperty_sys_repo - V script
CREATE View property.RepoObjectProperty_sys_repo
As
--
Select
    ro.RepoObject_guid
  , ses.property_name
  , ses.property_value
  , ses.SysObject_schema_name
  , ses.SysObject_name
  , link.RepoObjectProperty_id
  , RepoObjectProperty_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
            And ses.minor_name Is Null
            And ses.class             = 1 --OBJECT_OR_COLUMN
            --todo: handle class = 3 SCHEMA
            --todo: handle class = 7 INDEX
            And ses.property_name     <> 'RepoObject_guid'

    Left Join
        property.RepoObjectProperty As link
            On
            ro.RepoObject_guid        = link.RepoObject_guid
            And ses.property_name     = link.property_name