property.ExtendedProperty_Repo2Sys_level1 - V

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

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

Description

Examples

Entity Diagram

entity-property.extendedproperty_repo2sys_level1

Columns

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

nvarchar(128)

NOT NULL

varchar(128)

NULL

varchar(10)

NULL

nvarchar(4000)

NULL

uniqueidentifier

NOT NULL

char(2)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-property.extendedproperty_repo2sys_level1

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.extendedproperty_repo2sys_level1

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.extendedproperty_repo2sys_level1

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.extendedproperty_repo2sys_level1

Column Reference Diagram

entity_1_1_colref-property.extendedproperty_repo2sys_level1

Indexes

PK_ExtendedProperty_Repo2Sys_level1

idx_ExtendedProperty_Repo2Sys_level1__2

idx_ExtendedProperty_Repo2Sys_level1__3

idx_ExtendedProperty_Repo2Sys_level1__4

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

property_name

5

property_name

nvarchar(128)

NOT NULL

level2name

level2name

varchar(128)

NULL

level2type

level2type

varchar(10)

NULL

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_level1 - V script
CREATE View property.ExtendedProperty_Repo2Sys_level1
As
Select
    prop.property_name
  , property_value = Cast(prop.property_value As NVarchar(4000))
  , level0type     = N'Schema'
  , level0name     = ro.RepoObject_schema_name
  , lev.level1type
  , level1name     = ro.RepoObject_name
  , lev.level2type
  , level2name     = Cast(Null As Varchar(128))
  , prop.RepoObject_guid
  , ro.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
Where
    Not lev.level1type Is Null
    And lev.level2type Is Null