repo.Index_ssas - V
type: V ( view ), modify_date: 2021-09-10 14:11:02
RepoObject_guid: 909CF1C3-0B08-EC11-8515-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
PK_Index_ssas
-
IndexSemanticGroup: no_group
-
databasename; nvarchar(128)
-
[column-index_name]; nvarchar(450)
-
-
PK, Unique, Real: 1, 1, 0
UK_Index_ssas__1
-
IndexSemanticGroup: no_group
-
[column-index_name]; nvarchar(450)
-
-
PK, Unique, Real: 0, 1, 0
Column Details
_
sql_modules_definition
repo.Index_ssas - V script
/*Index can contain only one colum, so we can just include it
formally the right way would be to group by*/
CREATE View repo.Index_ssas
As
Select
Distinct
--logical PK: databasename,index_name
databasename
, index_name
--unique attributes per index
, is_index_primary_key
, is_index_unique
, RepoObject_guid
--, TableID
, TableName
--is unique per Index, because one index connects one pair of columns
, ColumnName
From
ssas.IndexColumn_union
Where
Not index_name Is Null