sqlparse.RepoObject_SqlModules_39_object - V

type: V ( view ), modify_date: 2021-08-17 20:12:22

RepoObject_guid: 0190291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_39_object

Columns

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

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

bigint

NULL

bigint

NULL

bigint

NULL

bigint

NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_39_object

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_39_object

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_39_object

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_39_object

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_39_object

Indexes

idx_RepoObject_SqlModules_39_object__1

Column Details

_

has_GroupBy

has_GroupBy

int

NULL

is_1_create

is_1_create

int

NULL

is_2_view

is_2_view

int

NULL

is_3_Identifier

is_3_Identifier

int

NULL

is_4_as

is_4_as

int

NULL

is_5_select

is_5_select

int

NULL

is_6_Identifier

is_6_Identifier

int

NULL

is_6_IdentifierList

is_6_IdentifierList

int

NULL

is_7_from

is_7_from

int

NULL

is_7_IdentifierList

is_7_IdentifierList

int

NULL

is_8_IdentifierList

is_8_IdentifierList

int

NULL

is_create_view_Identifier_as_select

is_create_view_Identifier_as_select

int

NULL

is_select_IdentifierList_from

is_select_IdentifierList_from

int

NULL

is_union

is_union

int

NULL

Min_RowNumber_From

Min_RowNumber_From

bigint

NULL

Min_RowNumber_GroupBy

Min_RowNumber_GroupBy

bigint

NULL

Min_RowNumber_IdentifierList

Min_RowNumber_IdentifierList

bigint

NULL

Min_RowNumber_Where

Min_RowNumber_Where

bigint

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

sqlparse.RepoObject_SqlModules_39_object - V script
CREATE View sqlparse.RepoObject_SqlModules_39_object
As
--
Select
    T1.RepoObject_guid
  , is_create_view_Identifier_as_select = T31.is_1_create * T31.is_2_view * T31.is_3_Identifier * T31.is_4_as
                                          * T31.is_5_select
  , is_select_IdentifierList_from       = T31.is_5_select * T31.is_6_IdentifierList * T31.is_7_from
  , Min_RowNumber_IdentifierList        = T32_1.Min_RowNumber_per_class
  , Min_RowNumber_From                  = T33_1.Min_RowNumber_per_normalized
  , Min_RowNumber_GroupBy               = T33_2.Min_RowNumber_per_normalized
  , Min_RowNumber_Where                 = T32_2.Min_RowNumber_per_class
  --the following columns are for easy issue tracking
  , ro.SysObject_fullname
  , T31.is_1_create
  , T31.is_2_view
  , T31.is_3_Identifier
  , T31.is_4_as
  , T31.is_5_select
  , T31.is_6_Identifier
  , T31.is_6_IdentifierList
  , T31.is_7_from
  , T31.is_7_IdentifierList
  , T31.is_8_IdentifierList
  , T26.is_union
  , T27.has_GroupBy
From
    sqlparse.RepoObject_SqlModules                            As T1
    Left Outer Join
        repo.RepoObject                                       As ro
            On
            ro.RepoObject_guid    = T1.RepoObject_guid

    Left Outer Join
        sqlparse.RepoObject_SqlModules_31_object              As T31
            On
            T31.RepoObject_guid   = T1.RepoObject_guid

    Left Outer Join
        sqlparse.RepoObject_SqlModules_32_ObjectClass         As T32_1
            On
            T32_1.RepoObject_guid = T1.RepoObject_guid
            And T32_1.class       = 'IdentifierList'

    Left Outer Join
        sqlparse.RepoObject_SqlModules_32_ObjectClass         As T32_2
            On
            T32_2.RepoObject_guid = T1.RepoObject_guid
            And T32_2.class       = 'WHERE'

    Left Outer Join
        sqlparse.RepoObject_SqlModules_33_ObjectNormalized    As T33_1
            On
            T33_1.RepoObject_guid = T1.RepoObject_guid
            And T33_1.normalized  = 'FROM'

    Left Outer Join
        sqlparse.RepoObject_SqlModules_33_ObjectNormalized    As T33_2
            On
            T33_2.RepoObject_guid = T1.RepoObject_guid
            And T33_2.normalized  = 'GROUP BY'

    Left Outer Join
        sqlparse.RepoObject_SqlModules_29_1_object_is_union   As T26
            On
            T26.RepoObject_guid   = T1.RepoObject_guid

    Left Outer Join
        sqlparse.RepoObject_SqlModules_29_2_object_is_GroupBy As T27
            On
            T27.RepoObject_guid   = T1.RepoObject_guid