sqlparse.RepoObject_SqlModules_24_IdentifierList_children - V

type: V ( view ), modify_date: 2021-08-17 20:07:39

RepoObject_guid: 3B90291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_24_identifierlist_children

Columns

Table 1. Columns of sqlparse.RepoObject_SqlModules_24_IdentifierList_children - V
PK Column Name Data Type NULL? ID

1

uniqueidentifier

NOT NULL

2

nvarchar(4000)

NOT NULL

3

nvarchar(4000)

NOT NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

bigint

NULL

nvarchar(261)

NULL

nvarchar(500)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_24_identifierlist_children

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_24_identifierlist_children

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_24_identifierlist_children

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_24_identifierlist_children

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_24_identifierlist_children

Indexes

PK_RepoObject_SqlModules_24_IdentifierList_children

idx_RepoObject_SqlModules_24_IdentifierList_children__2

idx_RepoObject_SqlModules_24_IdentifierList_children__3

Column Details

_

T2_json_key

3

T2_json_key

nvarchar(4000)

NOT NULL

child0_children

child0_children

nvarchar(max)

NULL

child0_class

child0_class

nvarchar(500)

NULL

child0_is_group

child0_is_group

bit

NULL

child0_is_keyword

child0_is_keyword

bit

NULL

child0_is_whitespace

child0_is_whitespace

bit

NULL

child0_normalized

child0_normalized

nvarchar(max)

NULL

child1_children

child1_children

nvarchar(max)

NULL

child1_class

child1_class

nvarchar(500)

NULL

child1_is_group

child1_is_group

bit

NULL

child1_is_keyword

child1_is_keyword

bit

NULL

child1_is_whitespace

child1_is_whitespace

bit

NULL

child1_normalized

child1_normalized

nvarchar(max)

NULL

child2_children

child2_children

nvarchar(max)

NULL

child2_class

child2_class

nvarchar(500)

NULL

child2_is_group

child2_is_group

bit

NULL

child2_is_keyword

child2_is_keyword

bit

NULL

child2_is_whitespace

child2_is_whitespace

bit

NULL

child2_normalized

child2_normalized

nvarchar(max)

NULL

child3_children

child3_children

nvarchar(max)

NULL

child3_class

child3_class

nvarchar(500)

NULL

child3_is_group

child3_is_group

bit

NULL

child3_is_keyword

child3_is_keyword

bit

NULL

child3_is_whitespace

child3_is_whitespace

bit

NULL

child3_normalized

child3_normalized

nvarchar(max)

NULL

child4_children

child4_children

nvarchar(max)

NULL

child4_class

child4_class

nvarchar(500)

NULL

child4_is_group

child4_is_group

bit

NULL

child4_is_keyword

child4_is_keyword

bit

NULL

child4_is_whitespace

child4_is_whitespace

bit

NULL

child4_normalized

child4_normalized

nvarchar(max)

NULL

children

children

nvarchar(max)

NULL

Identifier_alias

Identifier_alias

nvarchar(max)

NULL

Identifier_source

Identifier_source

nvarchar(max)

NULL

Identifier_source_children

Identifier_source_children

nvarchar(max)

NULL

Identifier_source_class

Identifier_source_class

nvarchar(500)

NULL

is_group

is_group

bit

NULL

is_keyword

is_keyword

bit

NULL

is_whitespace

is_whitespace

bit

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


T2_class

T2_class

nvarchar(500)

NULL

sql_modules_definition

sqlparse.RepoObject_SqlModules_24_IdentifierList_children - V script
CREATE View sqlparse.RepoObject_SqlModules_24_IdentifierList_children
As
--
Select
    T1.RepoObject_guid
  , T1.json_key
  , T2_json_key                = T2.json_key
  , T1.SysObject_fullname
  , T1.RowNumber_per_Object
  , T1.class
  --, [T1].[is_group]
  --, [T1].[is_keyword]
  --, [T1].[is_whitespace]
  , T1.normalized
  --, [T1].[children]
  , T2_class                   = T2.class
  , Identifier_alias           = Case T2.class
                                     When 'Identifier'
                                         Then
                                         Case
                                             When T2.child1_normalized Is Null
                                                 Then
                                                 T2.child0_normalized
                                             When T2.child1_normalized = 'AS'
                                                 Then
                                                 T2.child2_normalized
                                             When T2.child3_normalized = 'AS'
                                                 Then
                                                 T2.child4_normalized
                                             When T2.child1_normalized = '.'
                                                 Then
                                                 T2.child2_normalized
                                         End
                                     When 'Comparison'
                                         Then
                                         Case
                                             When T2.child1_normalized = '='
                                                 Then
                                                 T2.child0_normalized
                                         End
                                 End
  , Identifier_source          = Case T2.class
                                     When 'Identifier'
                                         Then
                                         Case T2.child0_class
                                             When 'Token'
                                                 Then
                                                 T2.normalized
                                             When 'Function'
                                                 Then
                                                 T2.child0_normalized
                                         End
                                     When 'Comparison'
                                         Then
                                         Case
                                             When T2.child1_normalized = '='
                                                 Then
                                                 T2.child2_normalized
                                         End
                                 End
  , Identifier_source_class    = Case T2.class
                                     When 'Identifier'
                                         Then
                                         Case T2.child0_class
                                             When 'Token'
                                                 Then
                                                 T2.class
                                             When 'Function'
                                                 Then
                                                 T2.child0_class
                                         End
                                     When 'Comparison'
                                         Then
                                         Case
                                             When T2.child1_normalized = '='
                                                 Then
                                                 T2.child2_class
                                         End
                                 End
  , Identifier_source_children = Case T2.class
                                     When 'Identifier'
                                         Then
                                         Case T2.child0_class
                                             When 'Token'
                                                 Then
                                                 T2.children
                                             When 'Function'
                                                 Then
                                                 T2.child0_children
                                         End
                                     When 'Comparison'
                                         Then
                                         Case
                                             When T2.child1_normalized = '='
                                                 Then
                                                 T2.child2_children
                                         End
                                 End
  , T2.is_group
  , T2.is_keyword
  , T2.is_whitespace
  --, [T2].[normalized]
  , T2.children
  , T2.child0_class
  , T2.child0_is_group
  , T2.child0_is_keyword
  , T2.child0_is_whitespace
  , T2.child0_normalized
  , T2.child0_children
  , T2.child1_class
  , T2.child1_is_group
  , T2.child1_is_keyword
  , T2.child1_is_whitespace
  , T2.child1_normalized
  , T2.child1_children
  , T2.child2_class
  , T2.child2_is_group
  , T2.child2_is_keyword
  , T2.child2_is_whitespace
  , T2.child2_normalized
  , T2.child2_children
  , T2.child3_class
  , T2.child3_is_group
  , T2.child3_is_keyword
  , T2.child3_is_whitespace
  , T2.child3_normalized
  , T2.child3_children
  , T2.child4_class
  , T2.child4_is_group
  , T2.child4_is_keyword
  , T2.child4_is_whitespace
  , T2.child4_normalized
  , T2.child4_children
From
    sqlparse.RepoObject_SqlModules_20_statement_children                 As T1
    Cross Apply sqlparse.ftv_sqlparse_with_some_children ( T1.children ) As T2
Where
    T1.class = 'IdentifierList'
    And T2.class In
        ( 'Identifier', 'Comparison' )
----there was any reason for this filter
----now we remove it, but we need to check the case of 'Identifier'
-- AND [T2].[class] = 'Comparison'