repo.Index_ssas_IndexPatternColumnGuid - V

type: V ( view ), modify_date: 2021-08-28 16:57:06

RepoObject_guid: 41ECD625-1608-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.index_ssas_indexpatterncolumnguid

Columns

Table 1. Columns of repo.Index_ssas_IndexPatternColumnGuid - V
PK Column Name Data Type NULL? ID

uniqueidentifier

NOT NULL

varchar(8000)

NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_ssas_indexpatterncolumnguid

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_ssas_indexpatterncolumnguid

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_ssas_indexpatterncolumnguid

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_ssas_indexpatterncolumnguid

Column Reference Diagram

entity_1_1_colref-repo.index_ssas_indexpatterncolumnguid

Indexes

idx_Index_ssas_IndexPatternColumnGuid__1

Column Details

_

index_guid

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

IndexPatternColumnGuid

IndexPatternColumnGuid

varchar(8000)

NULL

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NULL

sql_modules_definition

repo.Index_ssas_IndexPatternColumnGuid - V script
create View repo.Index_ssas_IndexPatternColumnGuid
As
Select
    i.index_guid
  --only one [parent_RepoObject_guid] per index_guid is possible
  , parent_RepoObject_guid = Max ( i.RepoObject_guid )
  , IndexPatternColumnGuid =
  --
  String_Agg ( Cast(ic.RepoObjectColumn_guid As Char(36)), ',' ) Within Group(Order By
                                                                                  Cast(ic.RepoObjectColumn_guid As Char(36)))
From
    repo.Index_ssas_T           As i
    Inner Join
        repo.IndexColumn_ssas_T As ic
            On
            i.index_guid = ic.index_guid
Group By
    i.index_guid