property.PropertyName_Measure - V

type: V ( view ), modify_date: 2021-11-24 17:46:48

RepoObject_guid: F81EA651-464D-EC11-8531-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.propertyname_measure

Columns

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

1

nvarchar(128)

NULL

Foreign Key Diagram

entity_1_1_fk-property.propertyname_measure

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-property.propertyname_measure

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.propertyname_measure

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.propertyname_measure

Column Reference Diagram

entity_1_1_colref-property.propertyname_measure

Indexes

PK_PropertyName_Measure

Column Details

_

property_name

1

property_name

nvarchar(128)

NULL

sql_modules_definition

property.PropertyName_Measure - V script
/*
all used [property_name] in any Measure
*/

create View property.PropertyName_Measure
As
Select
    Distinct
    --
    property_name = Trim ( property_name )
From
    property.MeasureProperty