property.ExtendedProperty_Repo2Sys_level2_Union

Description

Examples

Entity Diagram

Columns

Table 1. Columns of property.ExtendedProperty_Repo2Sys_level2_Union - V
PK	Column Name	Data Type	NULL?
1	level0type	`nvarchar(6)`	`NOT NULL`
2	level0name	`nvarchar(128)`	`NOT NULL`
3	level1type	`varchar(9)`	`NULL`
4	level1name	`nvarchar(128)`	`NOT NULL`
5	level2type	`nvarchar(10)`	`NULL`
6	level2name	`nvarchar(128)`	`NOT NULL`
7	property_name	`nvarchar(128)`	`NOT NULL`
	property_value	`nvarchar(4000)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_ExtendedProperty_Repo2Sys_level2_Union

IndexSemanticGroup: no_group
- level0type; nvarchar(6)
- level0name; nvarchar(128)
- level1type; varchar(9)
- level1name; nvarchar(128)
- level2type; nvarchar(10)
- level2name; nvarchar(128)
- [column-property_name]; nvarchar(128)
PK, Unique, Real: 1, 1, 0

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

level2type

5

level2type

nvarchar(10)

NULL

level2name

6

level2name

nvarchar(128)

NOT NULL

property_name

7

property_name

nvarchar(128)

NOT NULL

property_value

nvarchar(4000)

NULL

sql_modules_definition

property.ExtendedProperty_Repo2Sys_level2_Union - V script

CREATE View property.ExtendedProperty_Repo2Sys_level2_Union
As
Select
    --
    property_name
  , property_value
  , level0type
  , level0name
  , level1type
  , level1name
  , level2type
  , level2name
From
    property.ExtendedProperty_Repo2Sys_level2_RepoObject
Union All
Select
    --
    property_name
  , property_value
  , level0type
  , level0name
  , level1type
  , level1name
  , level2type
  , level2name
From
    property.ExtendedProperty_Repo2Sys_level2_RepoObjectColumn