ssas.model_json_31211_tables_columns_descriptions_StrAgg - V

type: V ( view ), modify_date: 2022-09-08 16:26:40

RepoObject_guid: E1F27B65-9D0F-EC11-8518-A81E8446D5B0

Description

Examples

Entity Diagram

entity-ssas.model_json_31211_tables_columns_descriptions_stragg

Columns

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

nvarchar(128)

NOT NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(500)

NOT NULL

nvarchar(128)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-ssas.model_json_31211_tables_columns_descriptions_stragg

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-ssas.model_json_31211_tables_columns_descriptions_stragg

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-ssas.model_json_31211_tables_columns_descriptions_stragg

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-ssas.model_json_31211_tables_columns_descriptions_stragg

Column Reference Diagram

entity_1_1_colref-ssas.model_json_31211_tables_columns_descriptions_stragg

Indexes

idx_model_json_31211_tables_columns_descriptions_StrAgg__1

idx_model_json_31211_tables_columns_descriptions_StrAgg__2

idx_model_json_31211_tables_columns_descriptions_StrAgg__3

idx_model_json_31211_tables_columns_descriptions_StrAgg__4

Column Details

_

databasename

databasename

nvarchar(128)

NOT NULL

descriptions_StrAgg

descriptions_StrAgg

nvarchar(max)

NULL

Measure_guid

Measure_guid

uniqueidentifier

NOT NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

tables_measures_name

tables_measures_name

nvarchar(500)

NOT NULL

tables_name

tables_name

nvarchar(128)

NOT NULL

sql_modules_definition

ssas.model_json_31211_tables_columns_descriptions_StrAgg - V script
CREATE View ssas.model_json_31211_tables_columns_descriptions_StrAgg
As
Select
    T1.databasename
  , T1.tables_name
  , T1.tables_measures_name
  , T1.RepoObject_guid
  , T1.Measure_guid
  , descriptions_StrAgg = String_Agg ( Cast(T1.Value As NVarchar(Max)), Char ( 13 ) + Char ( 10 )) Within Group(Order By
                                                                                                                    Try_Cast(T1.[Key] As Int))
From
    ssas.model_json_3121_tables_columns_descriptions_multiline As T1
Group By
    T1.databasename
  , T1.tables_name
  , T1.tables_measures_name
  , T1.RepoObject_guid
  , T1.Measure_guid