repo.Index_union - V

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

RepoObject_guid: 2590291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.index_union

Columns

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

1

uniqueidentifier

NULL

nvarchar(450)

NULL

tinyint

NULL

varchar(8000)

NULL

bit

NULL

bit

NULL

bit

NULL

bit

NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_union

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_union

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_union

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_union

Column Reference Diagram

entity_1_1_colref-repo.index_union

Indexes

PK_Index_union

Column Details

_

index_guid

1

index_guid

uniqueidentifier

NULL

index_name

index_name

nvarchar(450)

NULL

index_type

index_type

tinyint

NULL

IndexPatternColumnGuid

IndexPatternColumnGuid

varchar(8000)

NULL

is_index_disabled

is_index_disabled

bit

NULL

is_index_primary_key

is_index_primary_key

bit

NULL

is_index_real

is_index_real

bit

NULL

Referencing Columns

is_index_unique

is_index_unique

bit

NULL

Referencing Columns

referenced_index_guid

referenced_index_guid

uniqueidentifier

NULL

sql_modules_definition

repo.Index_union - V script
CREATE View repo.Index_union
As
--
Select
    T1.index_guid
  , T1.parent_RepoObject_guid
  , T1.index_name
  , T1.index_type
  , T1.is_index_unique
  , T1.is_index_primary_key
  , T1.is_index_disabled
  , T2.IndexPatternColumnGuid
  , referenced_index_guid = Null
  , is_index_real         = Cast(1 As Bit)
From
    repo_sys.Index_unique                        As T1
    Left Join
        repo.Index_unique_IndexPatternColumnGuid As T2
            On
            T2.index_guid = T1.index_guid
Union All
Select
    T1.index_guid
  , T1.parent_RepoObject_guid
  , T1.index_name
  , T1.index_type
  , T1.is_index_unique
  , T1.is_index_primary_key
  , T1.is_index_disabled
  , T2.IndexPatternColumnGuid
  , T1.referenced_index_guid
  , is_index_real = Cast(0 As Bit)
From
    repo.Index_virtual                            As T1
    Left Join
        repo.Index_virtual_IndexPatternColumnGuid As T2
            On
            T2.index_guid = T1.index_guid
Union All
Select
    T1.index_guid
  , T1.RepoObject_guid
  , T1.index_name
  , index_type            = Null
  , T1.is_index_unique
  , T1.is_index_primary_key
  , is_index_disabled     = Cast(0 As Bit)
  , T2.IndexPatternColumnGuid
  , referenced_index_guid = Null --maybe we need this later?
  , is_index_real         = Cast(1 As Bit)
From
    repo.Index_ssas_T                          As T1
    Left Join
        repo.Index_ssas_IndexPatternColumnGuid As T2
            On
            T2.index_guid = T1.index_guid