repo.IndexColumn_ssas - V

type: V ( view ), modify_date: 2021-09-10 14:14:27

RepoObject_guid: CCB100DE-0D08-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.indexcolumn_ssas

Columns

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

1

uniqueidentifier

NOT NULL

2

int

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(max)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.indexcolumn_ssas

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.indexcolumn_ssas

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.indexcolumn_ssas

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.indexcolumn_ssas

Column Reference Diagram

entity_1_1_colref-repo.indexcolumn_ssas

Indexes

PK_IndexColumn_ssas

idx_IndexColumn_ssas__2

idx_IndexColumn_ssas__3

Column Details

_

index_guid

1

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

index_column_id

2

index_column_id

int

NOT NULL

ColumnName

ColumnName

nvarchar(128)

NOT NULL

databasename

databasename

nvarchar(128)

NOT NULL

Referenced Columns

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

TableName

TableName

nvarchar(max)

NOT NULL

Referenced Columns
Referencing Columns

sql_modules_definition

repo.IndexColumn_ssas - V script
CREATE View repo.IndexColumn_ssas
As
Select
    --PK: index_guid,index_column_id
    i.index_guid
  , col.index_column_id
  --unique attriutes per IndexColum
  , col.RepoObjectColumn_guid
  , i.databasename
  --, i.TableID
  , i.TableName
  , ColumnName = col.ColumnName
--, ColumnType = col.type
From
    ssas.IndexColumn_union As col
    Inner Join
        repo.Index_ssas_T  As i
            On
            col.databasename   = i.databasename
            And col.index_name = i.index_name