repo.Index_unique_IndexPatternColumnGuid - V

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

RepoObject_guid: 5FCE8EB8-5F62-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

Columns

Table 1. Columns of repo.Index_unique_IndexPatternColumnGuid - V
PK	Column Name	Data Type	NULL?	ID
	index_guid	`uniqueidentifier`	`NULL`
	IndexPatternColumnGuid	`varchar(8000)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

repo_sys.IndexColumn_unique - V

Referencing Objects

repo.Index_union - V

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Indexes

idx_Index_unique_IndexPatternColumnGuid__1

IndexSemanticGroup: no_group
- [column-index_guid]; uniqueidentifier
PK, Unique, Real: 0, 0, 0

Column Details

_

index_guid

uniqueidentifier

NULL

Referenced Columns

repo_sys.IndexColumn_unique.index_guid

IndexPatternColumnGuid

varchar(8000)

NULL

sql_modules_definition

repo.Index_unique_IndexPatternColumnGuid - V script

CREATE View repo.Index_unique_IndexPatternColumnGuid
As
Select
    ic.index_guid
  , IndexPatternColumnGuid =
  --
  String_Agg ( Cast(ic.RepoObjectColumn_guid As Char(36)), ',' ) Within Group(Order By
                                                                                  Cast(ic.RepoObjectColumn_guid As Char(36)))
From
    repo_sys.IndexColumn_unique As ic
Group By
    ic.index_guid