ssas.model_json_201_descriptions_multiline - V

type: V ( view ), modify_date: 2021-09-01 16:16:03

RepoObject_guid: 24064FC7-110B-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_201_descriptions_multiline

Columns

Table 1. Columns of ssas.model_json_201_descriptions_multiline - V
PK Column Name Data Type NULL? ID

nvarchar(128)

NOT NULL

Key

nvarchar(4000)

NOT NULL

tinyint

NOT NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_201_descriptions_multiline

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_201_descriptions_multiline

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_201_descriptions_multiline

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_201_descriptions_multiline

Column Reference Diagram

entity_1_1_colref-ssas.model_json_201_descriptions_multiline

Indexes

idx_model_json_201_descriptions_multiline__1

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

Referenced Columns

Key

Key

nvarchar(4000)

NOT NULL

Type

Type

tinyint

NOT NULL

Value

Value

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_201_descriptions_multiline - V script
/*
Select
    Distinct
    j2.[Key]
  , j2.[value]
  , j2.Type
From
    ssas.model_json_20 As T1
    Cross Apply OpenJson ( T1.l2_description_ja )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                       As j2
order by
    j2.[Key]
Go
*/

CREATE View ssas.model_json_201_descriptions_multiline
As
Select
    T1.databasename
  , j2.[Key]
  , j2.Value
  , j2.Type
From
    ssas.model_json_20 As T1
    Cross Apply OpenJson ( T1.l2_description_ja )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                       As j2