ssas.model_json_3112_tables_columns_expressions_multiline - V

type: V ( view ), modify_date: 2021-09-01 18:27:26

RepoObject_guid: 1CFF988B-480B-EC11-8516-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_3112_tables_columns_expressions_multiline

Columns

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

nvarchar(128)

NOT NULL

Key

nvarchar(4000)

NOT NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

tinyint

NOT NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_3112_tables_columns_expressions_multiline

References

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_3112_tables_columns_expressions_multiline

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_3112_tables_columns_expressions_multiline

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_3112_tables_columns_expressions_multiline

Column Reference Diagram

entity_1_1_colref-ssas.model_json_3112_tables_columns_expressions_multiline

Indexes

idx_model_json_3112_tables_columns_expressions_multiline__1

idx_model_json_3112_tables_columns_expressions_multiline__2

idx_model_json_3112_tables_columns_expressions_multiline__3

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

Key

Key

nvarchar(4000)

NOT NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

tables_columns_name

tables_columns_name

nvarchar(128)

NOT NULL

tables_name

tables_name

nvarchar(128)

NOT NULL

Type

Type

tinyint

NOT NULL

Value

Value

nvarchar(max)

NULL

sql_modules_definition

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

Create View ssas.model_json_3112_tables_columns_expressions_multiline
As
Select
    T1.databasename
  , T1.tables_name
  , T1.tables_columns_name
  , T1.RepoObject_guid
  , T1.RepoObjectColumn_guid
  , j2.[Key]
  , j2.Value
  , j2.Type
From
    ssas.model_json_311_tables_columns_T As T1
    Cross Apply OpenJson ( T1.tables_columns_expression_ja )
                --As j1
                --Cross Apply OpenJson ( j1.Value )
                                         As j2