repo.Index_Settings_ForUpdate - V
type: V ( view ), modify_date: 2022-01-05 18:06:35
RepoObject_guid: 637159E3-27E6-EB11-8507-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_Index_Settings_ForUpdate__1
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
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