sys_self.ExtendedProperties_ParameterForAddUpdateDrop - V

type: V ( view ), modify_date: 2021-10-02 13:23:34

RepoObject_guid: E58F291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sys_self.extendedproperties_parameterforaddupdatedrop

Columns

Table 1. Columns of sys_self.ExtendedProperties_ParameterForAddUpdateDrop - V
PK Column Name Data Type NULL? ID

tinyint

NOT NULL

nvarchar(60)

NULL

nvarchar(128)

NULL

varchar(6)

NOT NULL

nvarchar(128)

NULL

varchar(9)

NULL

nvarchar(128)

NULL

varchar(10)

NULL

int

NOT NULL

sysname

NOT NULL

sql_variant

NULL

char(2)

NULL

varchar(9)

NULL

varchar(10)

NULL

Foreign Key Diagram

entity_1_1_fk-sys_self.extendedproperties_parameterforaddupdatedrop

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sys_self.extendedproperties_parameterforaddupdatedrop

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sys_self.extendedproperties_parameterforaddupdatedrop

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sys_self.extendedproperties_parameterforaddupdatedrop

Column Reference Diagram

entity_1_1_colref-sys_self.extendedproperties_parameterforaddupdatedrop

Column Details

_

class

class

tinyint

NOT NULL

class_desc

class_desc

nvarchar(60)

NULL

level0name

level0name

nvarchar(128)

NULL

level0type

level0type

varchar(6)

NOT NULL

level1name

level1name

nvarchar(128)

NULL

level1type

level1type

varchar(9)

NULL

level2name

level2name

nvarchar(128)

NULL

level2type

level2type

varchar(10)

NULL

minor_id

minor_id

int

NOT NULL

property_name

property_name

sysname

NOT NULL

property_value

property_value

sql_variant

NULL

type

type

char(2)

NULL

type_level1type

type_level1type

varchar(9)

NULL

type_level2type

type_level2type

varchar(10)

NULL

sql_modules_definition

sys_self.ExtendedProperties_ParameterForAddUpdateDrop - V script
CREATE View sys_self.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, sep.SysObject_name)
  , level2type      = Iif(stl.level2type = 'CONSTRAINT', stl.level2type, sep.level2type)
  , 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
    sys_self.ExtendedProperties            As sep
    Inner Join
        sys.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