sqlparse.RepoObject_SqlModules_29_2_object_is_GroupBy - V

type: V ( view ), modify_date: 2021-08-17 20:10:42

RepoObject_guid: FD8F291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

Columns

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

int

NOT NULL

uniqueidentifier

NOT NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_29_2_object_is_groupby

Indexes

idx_RepoObject_SqlModules_29_2_object_is_GroupBy__1

Column Details

_

has_GroupBy

has_GroupBy

int

NOT NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

sql_modules_definition

sqlparse.RepoObject_SqlModules_29_2_object_is_GroupBy - V script
CREATE View sqlparse.RepoObject_SqlModules_29_2_object_is_GroupBy
As
--
Select
    RepoObject_guid
  , has_GroupBy = 1
From
    sqlparse.RepoObject_SqlModules_20_statement_children
Where
    is_keyword     = 1
    And normalized = 'GROUP BY'
Group By
    RepoObject_guid