repo.Index_IndexPattern - V
type: V ( view ), modify_date: 2022-09-08 16:22:24
RepoObject_guid: 6A90291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_Index_IndexPattern__1
-
IndexSemanticGroup: no_group
-
[column-index_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
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