ssas.model_json_316_tables_descriptions_multiline - V
type: V ( view ), modify_date: 2021-09-01 18:22:02
RepoObject_guid: 1EFF988B-480B-EC11-8516-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_model_json_316_tables_descriptions_multiline__1
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-tables_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_model_json_316_tables_descriptions_multiline__2
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
ssas.model_json_316_tables_descriptions_multiline - V script
/*
Select
Distinct
j2.[Key]
, j2.[value]
, j2.Type
From
ssas.[model_json_31_tables_T] As T1
Cross Apply OpenJson ( T1.[tables_description_ja] )
--As j1
--Cross Apply OpenJson ( j1.Value )
As j2
order by
j2.[Key]
Go
*/
CREATE View [ssas].[model_json_316_tables_descriptions_multiline]
As
Select
T1.databasename
, T1.tables_name
, T1.RepoObject_guid
, j2.[Key]
, j2.Value
, j2.Type
From
ssas.model_json_31_tables_T As T1
Cross Apply OpenJson ( T1.tables_description_ja )
--As j1
--Cross Apply OpenJson ( j1.Value )
As j2