docs.IndexSemanticgroup - V
type: V ( view ), modify_date: 2022-09-08 16:23:46
RepoObject_guid: 891293B9-DE96-EB11-84F4-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
Indexes
idx_IndexSemanticgroup__1
-
IndexSemanticGroup: no_group
-
[column-IndexSemanticGroup]; nvarchar(512)
-
-
PK, Unique, Real: 0, 0, 0
idx_IndexSemanticgroup__2
-
IndexSemanticGroup: no_group
-
[column-cultures_name]; nvarchar(10)
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
docs.IndexSemanticgroup - V script
/*
<<property_start>>Description
<<property_end>>
*/
CREATE View docs.IndexSemanticgroup
As
Select
IndexSemanticGroup
, cultures_name
, AntoraIndexSemanticgroup = Char ( 13 ) + Char ( 10 )
--
+ '[#' + docs.fs_cleanStringForAnchorId ( IsNull ( IndexSemanticGroup, '(no group)' ))
+ ']' + Char ( 13 ) + Char ( 10 )
--
+ '== ' + IsNull ( IndexSemanticGroup, '(no group)' ) + Char ( 13 ) + Char ( 10 )
+ Char ( 13 ) + Char ( 10 )
--
+ String_Agg (
Cast(AntoraIndexSemanticgroupPatterndatatype As NVarchar(Max))
, Char ( 13 ) + Char ( 10 )
) Within Group(Order By
IndexPatternColumnDatatype)
From
docs.IndexSemanticgroupPatterndatatype
Group By
IndexSemanticGroup
, cultures_name