property.PropertyName_RepoObjectColumn - V

type: V ( view ), modify_date: 2021-08-17 18:56:03

RepoObject_guid: 5EB33A4A-426D-EB11-84E2-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.propertyname_repoobjectcolumn

Columns

Table 1. Columns of property.PropertyName_RepoObjectColumn - V
PK Column Name Data Type NULL? ID

1

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-property.propertyname_repoobjectcolumn

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.propertyname_repoobjectcolumn

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.propertyname_repoobjectcolumn

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.propertyname_repoobjectcolumn

Column Reference Diagram

entity_1_1_colref-property.propertyname_repoobjectcolumn

Indexes

PK_PropertyName_RepoObjectColumn

Column Details

_

property_name

1

property_name

nvarchar(128)

NOT NULL

sql_modules_definition

property.PropertyName_RepoObjectColumn - V script
CREATE View property.PropertyName_RepoObjectColumn
As
Select
    Distinct
    --
    property_name
From
    property.RepoObjectColumnProperty
Union
Select
    Distinct
    --
    sub_Parameter
From
    config.Parameter
Where
    Parameter_name In
    ( 'Inheritance_StringAggSeparatorSql_column', 'InheritanceDefinition_column', 'InheritanceType_column' )
    And sub_Parameter <> ''