docs.IndexSemanticgroup - V

type: V ( view ), modify_date: 2022-09-08 16:23:46

RepoObject_guid: 891293B9-DE96-EB11-84F4-A81E8446D5B0

Description

Examples

Entity Diagram

entity-docs.indexsemanticgroup

Columns

Table 1. Columns of docs.IndexSemanticgroup - V
PK Column Name Data Type NULL? ID

nvarchar(max)

NULL

nvarchar(10)

NULL

nvarchar(512)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.indexsemanticgroup

References

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.indexsemanticgroup

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.indexsemanticgroup

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.indexsemanticgroup

Column Reference Diagram

entity_1_1_colref-docs.indexsemanticgroup

Indexes

idx_IndexSemanticgroup__1

idx_IndexSemanticgroup__2

Column Details

_

AntoraIndexSemanticgroup

AntoraIndexSemanticgroup

nvarchar(max)

NULL

cultures_name

cultures_name

nvarchar(10)

NULL

IndexSemanticGroup

IndexSemanticGroup

nvarchar(512)

NULL

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