repo.Index_virtual_ForUpdate - V

type: V ( view ), modify_date: 2021-12-16 11:41:19

RepoObject_guid: 5F96B427-0B99-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.index_virtual_forupdate

Columns

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

bit

NOT NULL

uniqueidentifier

NOT NULL

nvarchar(128)

NULL

tinyint

NOT NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(512)

NULL

bit

NOT NULL

bit

NOT NULL

bit

NOT NULL

bit

NULL

bit

NULL

uniqueidentifier

NOT NULL

uniqueidentifier

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

int

NULL

nvarchar(261)

NOT NULL

nvarchar(257)

NOT NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_virtual_forupdate

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_virtual_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_virtual_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_virtual_forupdate

Column Reference Diagram

entity_1_1_colref-repo.index_virtual_forupdate

Indexes

idx_Index_virtual_ForUpdate__1

idx_Index_virtual_ForUpdate__2

Column Details

_

has_managedName

has_managedName

bit

NOT NULL

index_guid

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

index_name

index_name

nvarchar(128)

NULL

Referenced Columns

index_type

index_type

tinyint

NOT 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

is_persistence

is_persistence

bit

NULL

is_repo_managed

is_repo_managed

bit

NULL

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NOT NULL

referenced_index_guid

referenced_index_guid

uniqueidentifier

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NOT NULL

Description

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


RepoObject_fullname2

RepoObject_fullname2

nvarchar(257)

NOT NULL

Description

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


RowNumberInReferencing

RowNumberInReferencing

int

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NOT NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


SysObject_fullname2

SysObject_fullname2

nvarchar(257)

NOT NULL

Description

(concat([SysObject_schema_name],'.',[SysObject_name]))


sql_modules_definition

repo.Index_virtual_ForUpdate - V script
/*
can be used to update data in repo.Index_virtual
the RepoObject names are shown, can be used for sorting
*/
CREATE View [repo].[Index_virtual_ForUpdate]
As
Select
    iv.index_guid
  , iv.has_managedName
  , iv.index_name
  , iv.index_type
  , iv.is_index_disabled
  , iv.is_index_primary_key
  , iv.is_index_unique
  , iv.parent_RepoObject_guid
  , iv.referenced_index_guid
  , iv.RowNumberInReferencing
  , iset.IndexPatternColumnDatatype
  , iset.IndexPatternColumnName
  , iset.IndexSemanticGroup
  , ro.RepoObject_fullname
  , ro.RepoObject_fullname2
  , ro.SysObject_fullname
  , ro.SysObject_fullname2
  , parent.is_persistence
  , parent.is_repo_managed
From
    repo.Index_virtual        As iv
    Inner Join
        repo.RepoObject       As ro
            On
            ro.RepoObject_guid     = iv.parent_RepoObject_guid

    Left Join
        repo.Index_Settings   As iset
            On
            iset.index_guid        = iv.index_guid

    Left Join
        repo.RepoObject_gross As parent
            On
            parent.RepoObject_guid = iv.parent_RepoObject_guid