sqlparse.RepoObject_SqlModules_29_1_object_is_union - V
type: V ( view ), modify_date: 2021-08-17 20:10:16
RepoObject_guid: FB8F291C-9D61-EB11-84DC-A81E8446D5B0
Columns
| PK | Column Name | Data Type | NULL? | ID |
|---|---|---|---|---|
|
|
|||
|
|
Indexes
idx_RepoObject_SqlModules_29_1_object_is_union__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
sql_modules_definition
sqlparse.RepoObject_SqlModules_29_1_object_is_union - V script
--Objects, containing the keywords ('UNION', 'UNION ALL')
--We assume that it is UNION.
CREATE View sqlparse.RepoObject_SqlModules_29_1_object_is_union
As
--
Select
RepoObject_guid
, is_union = 1
From
sqlparse.RepoObject_SqlModules_20_statement_children
Where
( is_keyword = 1 )
And ( normalized In
( 'UNION', 'UNION ALL' )
)
Group By
RepoObject_guidsql