property.ExtendedProperty_Repo2Sys_level2_RepoObject - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: 56B33A4A-426D-EB11-84E2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.extendedproperty_repo2sys_level2_repoobject

Columns

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

1

nvarchar(6)

NOT NULL

2

nvarchar(128)

NOT NULL

3

varchar(9)

NULL

4

nvarchar(128)

NOT NULL

5

varchar(10)

NULL

6

nvarchar(128)

NOT NULL

7

nvarchar(128)

NOT NULL

uniqueidentifier

NOT NULL

char(2)

NOT NULL

nvarchar(4000)

NULL

uniqueidentifier

NOT NULL

char(2)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-property.extendedproperty_repo2sys_level2_repoobject

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.extendedproperty_repo2sys_level2_repoobject

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.extendedproperty_repo2sys_level2_repoobject

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.extendedproperty_repo2sys_level2_repoobject

Column Reference Diagram

entity_1_1_colref-property.extendedproperty_repo2sys_level2_repoobject

Indexes

PK_ExtendedProperty_Repo2Sys_level2_RepoObject

idx_ExtendedProperty_Repo2Sys_level2_RepoObject__2

idx_ExtendedProperty_Repo2Sys_level2_RepoObject__3

idx_ExtendedProperty_Repo2Sys_level2_RepoObject__4

idx_ExtendedProperty_Repo2Sys_level2_RepoObject__5

idx_ExtendedProperty_Repo2Sys_level2_RepoObject__6

Column Details

_

level0type

1

level0type

nvarchar(6)

NOT NULL

level0name

2

level0name

nvarchar(128)

NOT NULL

level1type

3

level1type

varchar(9)

NULL

level1name

4

level1name

nvarchar(128)

NOT NULL

Referenced Columns

level2type

5

level2type

varchar(10)

NULL

level2name

6

level2name

nvarchar(128)

NOT NULL

Referenced Columns

property_name

7

property_name

nvarchar(128)

NOT NULL

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

parent_RepoObject_type

parent_RepoObject_type

char(2)

NOT NULL

Referenced Columns

property_value

property_value

nvarchar(4000)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObject_type

RepoObject_type

char(2)

NOT NULL

Referenced Columns

sql_modules_definition

property.ExtendedProperty_Repo2Sys_level2_RepoObject - V script
CREATE View property.ExtendedProperty_Repo2Sys_level2_RepoObject
As
Select
    prop.property_name
  , property_value         = Cast(prop.property_value As NVarchar(4000))
  , level0type             = N'Schema'
  , level0name             = ro_parent.RepoObject_schema_name
  , lev_parent.level1type
  , level1name             = ro_parent.RepoObject_name
  , lev.level2type
  , level2name             = ro.RepoObject_name
  , prop.RepoObject_guid
  , ro.RepoObject_type
  , parent_RepoObject_guid = ro_parent.RepoObject_guid
  , parent_RepoObject_type = ro_parent.RepoObject_type
From
    property.RepoObjectProperty            As prop
    Inner Join
        repo.RepoObject                    As ro
            On
            ro.RepoObject_guid     = prop.RepoObject_guid

    Inner Join
        configT.type_level1type_level2type As lev
            On
            lev.type               = ro.RepoObject_type

    Inner Join
        repo.RepoObject                    As ro_parent
            On
            ro_parent.SysObject_id = ro.SysObject_parent_object_id

    Inner Join
        configT.type_level1type_level2type As lev_parent
            On
            lev_parent.type        = ro_parent.RepoObject_type
Where
    Not lev.level2type Is Null
    And ro_parent.SysObject_id > 0