repo.Index_virtual_SysObject - V

type: V ( view ), modify_date: 2021-08-17 19:43:19

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

Description

Examples

Entity Diagram

entity-repo.index_virtual_sysobject

Columns

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

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(512)

NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NULL

uniqueidentifier

NULL

int

NULL

nvarchar(128)

NOT NULL

nvarchar(128)

NOT NULL

char(2)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_virtual_sysobject

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_virtual_sysobject

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_virtual_sysobject

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_virtual_sysobject

Column Reference Diagram

entity_1_1_colref-repo.index_virtual_sysobject

Indexes

idx_Index_virtual_SysObject__1

idx_Index_virtual_SysObject__2

idx_Index_virtual_SysObject__3

idx_Index_virtual_SysObject__4

Column Details

_

index_guid

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

index_name

index_name

nvarchar(128)

NULL

Referenced Columns

IndexPatternColumnDatatype

IndexPatternColumnDatatype

nvarchar(4000)

NULL

IndexPatternColumnName

IndexPatternColumnName

nvarchar(4000)

NULL

IndexSemanticGroup

IndexSemanticGroup

nvarchar(512)

NULL

is_index_disabled

is_index_disabled

bit

NOT NULL

is_index_primary_key

is_index_primary_key

bit

NOT NULL

is_index_unique

is_index_unique

bit

NOT NULL

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NOT NULL

pk_index_guid

pk_index_guid

uniqueidentifier

NULL

Referenced Columns

referenced_index_guid

referenced_index_guid

uniqueidentifier

NULL

SysObject_id

SysObject_id

int

NULL

Referenced Columns

SysObject_name

SysObject_name

nvarchar(128)

NOT NULL

Referenced Columns

SysObject_schema_name

SysObject_schema_name

nvarchar(128)

NOT NULL

SysObject_type

SysObject_type

char(2)

NULL

Referenced Columns

sql_modules_definition

repo.Index_virtual_SysObject - V script
CREATE View repo.Index_virtual_SysObject
As
--
Select
    iv.index_guid
  , iv.parent_RepoObject_guid
  , iv.index_name
  , iv.is_index_disabled
  , iv.is_index_unique
  , iv.is_index_primary_key
  , iv.referenced_index_guid
  , isg.IndexPatternColumnDatatype
  , isg.IndexPatternColumnName
  , isg.IndexSemanticGroup
  , ro.SysObject_id
  , ro.SysObject_schema_name
  , ro.SysObject_name
  , ro.SysObject_type
  , ro.pk_index_guid
From
    repo.Index_virtual      As iv
    Inner Join
        repo.RepoObject     As ro
            On
            iv.parent_RepoObject_guid = ro.RepoObject_guid

    Inner Join
        repo.Index_Settings As isg
            On
            isg.index_guid            = iv.index_guid