docs.IndexSemanticgroupPatterndatatype - V

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

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

Description

Examples

Entity Diagram

entity-docs.indexsemanticgrouppatterndatatype

Columns

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

1

nvarchar(512)

NULL

2

nvarchar(4000)

NULL

nvarchar(max)

NULL

nvarchar(10)

NULL

Foreign Key Diagram

entity_1_1_fk-docs.indexsemanticgrouppatterndatatype

References

Referencing Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-docs.indexsemanticgrouppatterndatatype

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-docs.indexsemanticgrouppatterndatatype

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-docs.indexsemanticgrouppatterndatatype

Column Reference Diagram

entity_1_1_colref-docs.indexsemanticgrouppatterndatatype

Indexes

PK_IndexSemanticgroupPatterndatatype

idx_IndexSemanticgroupPatterndatatype__2

Column Details

_

IndexSemanticGroup

1

IndexSemanticGroup

nvarchar(512)

NULL

IndexPatternColumnDatatype

2

IndexPatternColumnDatatype

nvarchar(4000)

NULL

AntoraIndexSemanticgroupPatterndatatype

AntoraIndexSemanticgroupPatterndatatype

nvarchar(max)

NULL

cultures_name

cultures_name

nvarchar(10)

NULL

sql_modules_definition

docs.IndexSemanticgroupPatterndatatype - V script
CREATE View docs.IndexSemanticgroupPatterndatatype
As
Select
    i.IndexSemanticGroup
  , i.IndexPatternColumnDatatype
  , rof.cultures_name
  , AntoraIndexSemanticgroupPatterndatatype =
  --
  String_Agg (
                 Concat (
                            Cast(N'' As NVarchar(Max))
                          --** xref:aaa.bbb.adoc#index-pk_ccc[aaa.bbb - pk_abc]
                          , '** xref:' + docs.fs_cleanStringForFilename ( i.RepoObject_fullname2 ) + '.adoc#'
                            + 'index-' + docs.fs_cleanStringForAnchorId ( i.index_name ) + '['
                            + docs.fs_cleanStringForHeader ( i.RepoObject_fullname2 ) + ' - '
                            + docs.fs_cleanStringForHeader ( i.index_name ) + '] +'
                          , Char ( 13 ) + Char ( 10 )
                          , i.IndexPatternColumnName
                          , ' +'
                          , Char ( 13 ) + Char ( 10 )
                          , i.IndexPatternColumnDatatype
                          , ' +'
                          , Char ( 13 ) + Char ( 10 )
                          , 'PK, Unique, Real: '
                          , i.is_index_primary_key
                          , ', '
                          , i.is_index_unique
                          , ', '
                          , i.is_index_real
                        )
               , Char ( 13 ) + Char ( 10 )
             ) Within Group(Order By
                                i.RepoObject_fullname2)
From
    repo.Index_gross                   As i
    Left Join
        docs.RepoObject_OutputFilter_T As rof
            On
            rof.RepoObject_guid = i.parent_RepoObject_guid
Where
    Not rof.cultures_name Is Null
    And i.is_external    = 0
    And i.is_DocsOutput  = 1
    And i.is_DocsExclude = 0
Group By
    i.IndexSemanticGroup
  , i.IndexPatternColumnDatatype
  , rof.cultures_name