repo.IndexColumn_ssas_gross - V

type: V ( view ), modify_date: 2022-01-05 18:06:33

RepoObject_guid: 696E8DEE-3D08-EC11-8515-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.indexcolumn_ssas_gross

Columns

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

nvarchar(128)

NULL

int

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(450)

NOT NULL

bit

NULL

bit

NOT NULL

bit

NULL

bit

NOT NULL

nvarchar(128)

NOT NULL

nvarchar(261)

NULL

nvarchar(128)

NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

uniqueidentifier

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.indexcolumn_ssas_gross

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.indexcolumn_ssas_gross

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.indexcolumn_ssas_gross

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.indexcolumn_ssas_gross

Column Reference Diagram

entity_1_1_colref-repo.indexcolumn_ssas_gross

Indexes

idx_IndexColumn_ssas_gross__1

idx_IndexColumn_ssas_gross__2

idx_IndexColumn_ssas_gross__3

idx_IndexColumn_ssas_gross__4

idx_IndexColumn_ssas_gross__5

Column Details

_

column_user_type_fullname

column_user_type_fullname

nvarchar(128)

NULL

index_column_id

index_column_id

int

NOT NULL

index_guid

index_guid

uniqueidentifier

NOT NULL

index_name

index_name

nvarchar(450)

NOT NULL

Referenced Columns

is_descending_key

is_descending_key

bit

NULL

is_index_primary_key

is_index_primary_key

bit

NOT NULL

is_index_real

is_index_real

bit

NULL

is_index_unique

is_index_unique

bit

NOT NULL

Object_column_name

Object_column_name

nvarchar(128)

NOT NULL

parent_Object_fullname

parent_Object_fullname

nvarchar(261)

NULL

Description

(concat('[',[RepoObject_schema_name],'].[',[RepoObject_name],']'))


parent_Object_name

parent_Object_name

nvarchar(128)

NULL

Referenced Columns

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NOT NULL

parent_schema_name

parent_schema_name

nvarchar(128)

NULL

RepoObjectColumn_guid

RepoObjectColumn_guid

uniqueidentifier

NOT NULL

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