ssas.model_json_31211_tables_columns_descriptions_StrAgg

Description

Examples

Entity Diagram

Columns

Table 1. Columns of ssas.model_json_31211_tables_columns_descriptions_StrAgg - V
Column Name	Data Type	NULL?
databasename	`nvarchar(128)`	`NOT NULL`
descriptions_StrAgg	`nvarchar(max)`	`NULL`
Measure_guid	`uniqueidentifier`	`NOT NULL`
RepoObject_guid	`uniqueidentifier`	`NOT NULL`
tables_measures_name	`nvarchar(500)`	`NOT NULL`
tables_name	`nvarchar(128)`	`NOT NULL`

Foreign Key Diagram

References

Referenced Objects

ssas.model_json_3121_tables_columns_descriptions_multiline - V

Referencing Objects

repo.Measure - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_model_json_31211_tables_columns_descriptions_StrAgg__1

IndexSemanticGroup: no_group
- [column-Measure_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

idx_model_json_31211_tables_columns_descriptions_StrAgg__2

IndexSemanticGroup: ssas_table_measure
- databasename; nvarchar(128)
- [column-tables_name]; nvarchar(128)
- [column-tables_measures_name]; nvarchar(500)
PK, Unique, Real: 0, 0, 0

idx_model_json_31211_tables_columns_descriptions_StrAgg__3

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

idx_model_json_31211_tables_columns_descriptions_StrAgg__4

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

Column Details

_

databasename

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_3121_tables_columns_descriptions_multiline.databasename

descriptions_StrAgg

nvarchar(max)

NULL

Measure_guid

uniqueidentifier

NOT NULL

Referenced Columns

ssas.model_json_3121_tables_columns_descriptions_multiline.Measure_guid

RepoObject_guid

uniqueidentifier

NOT NULL

Referenced Columns

ssas.model_json_3121_tables_columns_descriptions_multiline.RepoObject_guid

tables_measures_name

nvarchar(500)

NOT NULL

Referenced Columns

ssas.model_json_3121_tables_columns_descriptions_multiline.tables_measures_name

tables_name

nvarchar(128)

NOT NULL

Referenced Columns

ssas.model_json_3121_tables_columns_descriptions_multiline.tables_name

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

sql