property.ExtendedProperty_Repo2Sys_level2_RepoObject - V
type: V ( view ), modify_date: 2021-10-02 13:23:34
RepoObject_guid: 56B33A4A-426D-EB11-84E2-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
3 |
|
|
||
4 |
|
|
||
5 |
|
|
||
6 |
|
|
||
7 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_ExtendedProperty_Repo2Sys_level2_RepoObject
-
IndexSemanticGroup: no_group
-
level0type; nvarchar(6)
-
level0name; nvarchar(128)
-
level1type; varchar(9)
-
level1name; nvarchar(128)
-
level2type; varchar(10)
-
level2name; nvarchar(128)
-
[column-property_name]; nvarchar(128)
-
-
PK, Unique, Real: 1, 1, 0
idx_ExtendedProperty_Repo2Sys_level2_RepoObject__2
-
IndexSemanticGroup: no_group
-
[column-parent_RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_ExtendedProperty_Repo2Sys_level2_RepoObject__3
-
IndexSemanticGroup: no_group
-
level0name; nvarchar(128)
-
level2name; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ExtendedProperty_Repo2Sys_level2_RepoObject__4
-
IndexSemanticGroup: no_group
-
level1name; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ExtendedProperty_Repo2Sys_level2_RepoObject__5
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-property_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_ExtendedProperty_Repo2Sys_level2_RepoObject__6
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
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