repo_sys.ExtendedProperties_ParameterForAddUpdateDrop - V
type: V ( view ), modify_date: 2021-10-02 13:23:34
RepoObject_guid: 4D90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
sql_modules_definition
repo_sys.ExtendedProperties_ParameterForAddUpdateDrop - V script
CREATE View repo_sys.ExtendedProperties_ParameterForAddUpdateDrop
As
--
Select
sep.property_name
, sep.property_value
, level0type = 'SCHEMA'
, level0name = sep.SysObject_schema_name
, level1type = Iif(stl.level2type = 'CONSTRAINT', 'TABLE', stl.level1type)
, level1name = Iif(stl.level2type = 'CONSTRAINT'
, sep.parent_name Collate Database_Default
, sep.SysObject_name Collate Database_Default)
, level2type = Iif(stl.level2type = 'CONSTRAINT', stl.level2type, sep.level2type Collate Database_Default)
, level2name = Iif(stl.level2type = 'CONSTRAINT', sep.SysObject_name, sep.minor_name)
, sep.minor_id
, sep.class
, sep.class_desc
, so.type
, type_level1type = stl.level1type
, type_level2type = stl.level2type
From
repo_sys.ExtendedProperties As sep
Inner Join
sys_dwh.objects As so
On
sep.major_id = so.object_id
Inner Join
configT.type_level1type_level2type As stl
On
so.type Collate Database_Default = stl.type