repo.Index_IndexPattern - V

type: V ( view ), modify_date: 2022-09-08 16:22:24

RepoObject_guid: 6A90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.index_indexpattern

Columns

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

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

Foreign Key Diagram

entity_1_1_fk-repo.index_indexpattern

References

Referenced Objects

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.index_indexpattern

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.index_indexpattern

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.index_indexpattern

Column Reference Diagram

entity_1_1_colref-repo.index_indexpattern

Indexes

idx_Index_IndexPattern__1

Column Details

_

index_guid

index_guid

uniqueidentifier

NOT NULL

IndexPatternColumnDatatype

IndexPatternColumnDatatype

nvarchar(max)

NULL

IndexPatternColumnName

IndexPatternColumnName

nvarchar(max)

NULL

sql_modules_definition

repo.Index_IndexPattern - V script
CREATE View repo.Index_IndexPattern
As
--
Select
    index_guid
  , IndexPatternColumnName     = String_Agg ( Cast(SysObject_column_name As NVarchar(Max)), ',' ) Within Group(Order By
                                                                                                                   index_column_id)
  , IndexPatternColumnDatatype = String_Agg ( Cast(SysObject_column_user_type_fullname As NVarchar(Max)), ',' ) Within Group(Order By
                                                                                                                                 index_column_id)
From
    repo.IndexColumn_union_T
Where
    Not index_guid Is Null
Group By
    index_guid