ssas.model_json_31_tables - V
type: V ( view ), modify_date: 2021-09-20 15:15:59
RepoObject_guid: F15FD8EE-E90A-EC11-8516-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_model_json_31_tables
-
IndexSemanticGroup: ssas_table
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 1, 1, 0
idx_model_json_31_tables__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
ssas.model_json_31_tables - V script
/*
--check
Select
Distinct
j2.[Key]
, j2.Type
From
ssas.model_json_20 As T1
Cross Apply OpenJson ( T1.l2_tables_ja ) As j1
Cross Apply OpenJson ( j1.Value ) As j2
order by
j2.[Key]
, j2.Type
Go
*/
CREATE View ssas.model_json_31_tables
As
Select
T1.databasename
--, T1.l1_name
--, T1.l1_compatibilityLevel
--, T1.l1_id
--, T1.l2_name
--, T1.l2_annotations_ja
--, T1.l2_culture
--, T1.l2_cultures_ja
--, T1.l2_dataSources_ja
--, T1.l2_perspectives_ja
--, T1.l2_relationships_ja
--, T1.l2_roles_ja
--, T1.l2_tables_ja
, j2.tables_name
, j2.tables_annotations_ja
, j2.tables_columns_ja
, j2.tables_dataCategory
, j2.tables_description
, j2.tables_description_ja
, j2.tables_hierarchies_ja
, j2.tables_isHidden
, j2.tables_measures_ja
, j2.tables_partitions_ja
From
ssas.model_json_20 As T1
Cross Apply OpenJson ( T1.l2_tables_ja ) As j1
Cross Apply
OpenJson ( j1.Value )
With
(
tables_name NVarchar ( 128 ) N'$.name'
, tables_annotations_ja NVarchar ( Max ) N'$.annotations' As Json
, tables_columns_ja NVarchar ( Max ) N'$.columns' As Json
, tables_dataCategory NVarchar ( 500 ) N'$.dataCategory'
, tables_description NVarchar ( Max ) N'$.description'
, tables_description_ja NVarchar ( Max ) N'$.description' As Json
, tables_hierarchies_ja NVarchar ( Max ) N'$.hierarchies' As Json
, tables_isHidden Bit N'$.isHidden'
, tables_measures_ja NVarchar ( Max ) N'$.measures' As Json
, tables_partitions_ja NVarchar ( Max ) N'$.partitions' As Json
) As j2