property.ExtendedProperty_Repo2Sys_level0 - V

type: V ( view ), modify_date: 2021-11-16 11:50:23

RepoObject_guid: 7FE30B53-11A4-EB11-84FA-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.extendedproperty_repo2sys_level0

Columns

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

nvarchar(128)

NOT NULL

nvarchar(6)

NOT NULL

nvarchar(128)

NULL

nvarchar(128)

NULL

varchar(128)

NULL

nvarchar(128)

NULL

varchar(14)

NOT NULL

nvarchar(4000)

NULL

Foreign Key Diagram

entity_1_1_fk-property.extendedproperty_repo2sys_level0

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-property.extendedproperty_repo2sys_level0

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.extendedproperty_repo2sys_level0

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.extendedproperty_repo2sys_level0

Column Reference Diagram

entity_1_1_colref-property.extendedproperty_repo2sys_level0

Indexes

idx_ExtendedProperty_Repo2Sys_level0__1

Column Details

_

level0name

level0name

nvarchar(128)

NOT NULL

Referenced Columns

level0type

level0type

nvarchar(6)

NOT NULL

level1name

level1name

nvarchar(128)

NULL

level1type

level1type

nvarchar(128)

NULL

level2name

level2name

varchar(128)

NULL

level2type

level2type

nvarchar(128)

NULL

property_name

property_name

varchar(14)

NOT NULL

property_value

property_value

nvarchar(4000)

NULL

sql_modules_definition

property.ExtendedProperty_Repo2Sys_level0 - V script
CREATE View property.ExtendedProperty_Repo2Sys_level0
As
Select
    property_name  = 'MS_Description'
  , property_value = rs.[RepoSchema_description]
  , level0type     = N'Schema'
  , level0name     = rs.RepoSchema_name
  , level1type     = Cast(Null As NVarchar(128))
  , level1name     = Cast(Null As NVarchar(128))
  , level2type     = Cast(Null As NVarchar(128))
  , level2name     = Cast(Null As Varchar(128))
From
    repo.RepoSchema As rs
Where
    Not rs.[RepoSchema_description] Is Null

--Select
--    prop.property_name
--  , prop.property_value
--  , level0type = N'Schema'
--  , level0name = RepoSchema_name
--  , level1type = Cast(Null As NVarchar(128))
--  , level1name = Cast(Null As NVarchar(128))
--  , level2type = Cast(Null As NVarchar(128))
--  , level2name = Cast(Null As Varchar(128))
--From
--    [property].RepoSchemaProperty               As prop