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
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
Indexes
idx_RepoObject_SqlModules_29_2_object_is_GroupBy__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
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