ssas.model_json_34_cultures - V :: DataHandwerk Docs

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssas.model_json_34_cultures - V
PK	Column Name	Data Type	NULL?
1	databasename	`nvarchar(128)`	`NOT NULL`
2	cultures_name	`nvarchar(500)`	`NULL`
	cultures_translations_j	`nvarchar(max)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

ssas.model_json_20 - V

Referencing Objects

ssas.model_json_341_cultures_translations - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

PK_model_json_34_cultures

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
- [column-cultures_name]; nvarchar(500)
PK, Unique, Real: 1, 1, 0

idx_model_json_34_cultures__2

IndexSemanticGroup: no_group
- databasename; nvarchar(128)
PK, Unique, Real: 0, 0, 0

Column Details

_

databasename

1

databasename

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_20.databasename

Referencing Columns

ssas.model_json_341_cultures_translations.databasename

cultures_name

2

cultures_name

nvarchar(500)

NULL

Referencing Columns

ssas.model_json_341_cultures_translations.cultures_name

cultures_translations_j

nvarchar(max)

NULL

sql_modules_definition

ssas.model_json_34_cultures - V script

/*
--check

Select
    Distinct
    j2.[Key]
  , j2.Type
From
    ssas.model_json_20                         As T1
    Cross Apply OpenJson ( T1.l2_cultures_ja ) As j1
    Cross Apply OpenJson ( j1.Value ) As j2
order by
    j2.[Key]
  , j2.Type
Go
*/
CREATE View ssas.model_json_34_cultures
As
Select
    T1.databasename
  , j2.cultures_name
  , j2.cultures_translations_j
From
    ssas.model_json_20                         As T1
    Cross Apply OpenJson ( T1.l2_cultures_ja ) As j1
    Cross Apply
    OpenJson ( j1.Value )
    With
    (
        cultures_name NVarchar ( 500 ) N'$.name'
      , cultures_translations_j NVarchar ( Max ) N'$.translations' As Json
    ) As j2