repo.Index_Settings_ForUpdate - V

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

RepoObject_guid: 637159E3-27E6-EB11-8507-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.index_settings_forupdate

Columns

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

uniqueidentifier

NOT NULL

nvarchar(450)

NULL

nvarchar(4000)

NULL

nvarchar(4000)

NULL

nvarchar(512)

NULL

bit

NOT NULL

uniqueidentifier

NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_settings_forupdate

References

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_settings_forupdate

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_settings_forupdate

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_settings_forupdate

Column Reference Diagram

entity_1_1_colref-repo.index_settings_forupdate

Indexes

idx_Index_Settings_ForUpdate__1

Column Details

_

index_guid

index_guid

uniqueidentifier

NOT NULL

Referenced Columns

index_name

index_name

nvarchar(450)

NULL

Referenced Columns

IndexPatternColumnDatatype

IndexPatternColumnDatatype

nvarchar(4000)

NULL

IndexPatternColumnName

IndexPatternColumnName

nvarchar(4000)

NULL

IndexSemanticGroup

IndexSemanticGroup

nvarchar(512)

NULL

is_create_constraint

is_create_constraint

bit

NOT NULL

parent_RepoObject_guid

parent_RepoObject_guid

uniqueidentifier

NULL

RepoObject_fullname

RepoObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

repo.Index_Settings_ForUpdate - V script
CREATE View repo.Index_Settings_ForUpdate
As
Select
    T1.index_guid
  , T1.IndexPatternColumnDatatype
  , T1.IndexPatternColumnName
  , T1.IndexSemanticGroup
  , T1.is_create_constraint
  , T2.index_name
  , T2.parent_RepoObject_guid
  , T3.RepoObject_fullname
From
    repo.Index_Settings  As T1
    Inner Join
        repo.Index_union As T2
            On
            T2.index_guid      = T1.index_guid

    Left Outer Join
        repo.RepoObject  As T3
            On
            T3.RepoObject_guid = T2.parent_RepoObject_guid