property.RepoObjectProperty_Collect_source_uspgenerator - V

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

RepoObject_guid: B5FE9885-EA9D-EB11-84F6-A81E8446D5B0

Description

Examples

Entity Diagram

entity-property.repoobjectproperty_collect_source_uspgenerator

Columns

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

1

uniqueidentifier

NULL

2

varchar(14)

NOT NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-property.repoobjectproperty_collect_source_uspgenerator

References

Object Reference Diagram - 1 1

entity_1_1_objectref-property.repoobjectproperty_collect_source_uspgenerator

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-property.repoobjectproperty_collect_source_uspgenerator

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-property.repoobjectproperty_collect_source_uspgenerator

Column Reference Diagram

entity_1_1_colref-property.repoobjectproperty_collect_source_uspgenerator

Indexes

PK_RepoObjectProperty_Collect_source_uspgenerator

idx_RepoObjectProperty_Collect_source_uspgenerator__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NULL

property_name

2

property_name

varchar(14)

NOT NULL

property_value

property_value

nvarchar(max)

NULL

sql_modules_definition

property.RepoObjectProperty_Collect_source_uspgenerator - V script
CREATE View property.RepoObjectProperty_Collect_source_uspgenerator
As
Select
    ro.RepoObject_guid
  , property_name  = p_names.property_name
  , property_value = Case p_names.property_name
                         When 'AdocUspSteps'
                             Then
                             Cast(ro.AdocUspSteps As NVarchar(Max))
                         When 'UspParameters'
                             Then
                             Cast(ro.UspParameters As NVarchar(Max))
                         When 'ExampleUsage'
                             Then
                             Cast(ro.UspExamples As NVarchar(Max))
                         When 'MS_Description'
                             Then
                             Cast(ro.MS_Description As NVarchar(Max))
                     End
From
    uspgenerator.GeneratorUsp_SqlUsp As ro
    Cross Join
    (
        Values
            ( 'AdocUspSteps' )
          , ( 'UspParameters' )
          , ( 'ExampleUsage' )
          , ( 'MS_Description' )
    )                                As p_names ( property_name )
Where
    Not ro.RepoObject_guid Is Null