repo.IndexColumn_ssas_gross - V
type: V ( view ), modify_date: 2022-01-05 18:06:33
RepoObject_guid: 696E8DEE-3D08-EC11-8515-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_IndexColumn_ssas_gross__1
-
IndexSemanticGroup: no_group
-
[column-parent_schema_name]; nvarchar(128)
-
[column-parent_Object_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ssas_gross__2
-
IndexSemanticGroup: no_group
-
[column-Object_column_name]; nvarchar(128)
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ssas_gross__3
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ssas_gross__4
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexColumn_ssas_gross__5
-
IndexSemanticGroup: no_group
-
[column-index_name]; nvarchar(450)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
parent_Object_fullname
parent_Object_fullname |
|
|
(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))
sql_modules_definition
repo.IndexColumn_ssas_gross - V script
Create View repo.IndexColumn_ssas_gross
As
Select
icv.index_guid
, icv.index_column_id
, icv.is_descending_key
, icv.RepoObjectColumn_guid
, parent_RepoObject_guid = iv.RepoObject_guid
, iv.index_name
, parent_schema_name = ro.RepoObject_schema_name
, parent_Object_name = ro.RepoObject_name
, Object_column_name = roc.RepoObjectColumn_name
, column_user_type_fullname = roc.Repo_user_type_fullname
, iv.is_index_unique
, iv.is_index_primary_key
, parent_Object_fullname = ro.RepoObject_fullname
, is_index_real = Cast(1 As Bit)
From
repo.IndexColumn_ssas_T As icv
Inner Join
repo.Index_ssas_T As iv
On
icv.index_guid = iv.index_guid
Inner Join
repo.RepoObjectColumn As roc
On
roc.RepoObjectColumn_guid = icv.RepoObjectColumn_guid
Left Join
repo.RepoObject As ro
On
ro.RepoObject_guid = iv.RepoObject_guid