property.RepoObjectProperty_sys_repo - V
type: V ( view ), modify_date: 2021-08-17 19:05:41
RepoObject_guid: 5790291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_RepoObjectProperty_sys_repo
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
[column-property_name]; sysname
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObjectProperty_sys_repo__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
property.RepoObjectProperty_sys_repo - V script
CREATE View property.RepoObjectProperty_sys_repo
As
--
Select
ro.RepoObject_guid
, ses.property_name
, ses.property_value
, ses.SysObject_schema_name
, ses.SysObject_name
, link.RepoObjectProperty_id
, RepoObjectProperty_property_value = link.property_value
From
repo_sys.ExtendedProperties As ses
Inner Join
repo.RepoObject As ro
On
ses.SysObject_schema_name = ro.SysObject_schema_name
And ses.SysObject_name = ro.SysObject_name
And ses.minor_name Is Null
And ses.class = 1 --OBJECT_OR_COLUMN
--todo: handle class = 3 SCHEMA
--todo: handle class = 7 INDEX
And ses.property_name <> 'RepoObject_guid'
Left Join
property.RepoObjectProperty As link
On
ro.RepoObject_guid = link.RepoObject_guid
And ses.property_name = link.property_name