sqlparse.RepoObject_SqlModules_39_object - V
type: V ( view ), modify_date: 2021-08-17 20:12:22
RepoObject_guid: 0190291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Indexes
idx_RepoObject_SqlModules_39_object__1
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
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