sqlparse.RepoObject_SqlModules_32_ObjectClass - V
type: V ( view ), modify_date: 2021-08-17 20:11:29
RepoObject_guid: FF8F291C-9D61-EB11-84DC-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
1 |
|
|
||
2 |
|
|
||
|
|
|||
|
|
Indexes
PK_RepoObject_SqlModules_32_ObjectClass
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
class; nvarchar(500)
-
-
PK, Unique, Real: 1, 1, 0
idx_RepoObject_SqlModules_32_ObjectClass__2
-
IndexSemanticGroup: no_group
-
[column-RepoObject_guid]; uniqueidentifier
-
-
PK, Unique, Real: 0, 0, 0
Column Details
_
sql_modules_definition
sqlparse.RepoObject_SqlModules_32_ObjectClass - V script
CREATE View sqlparse.RepoObject_SqlModules_32_ObjectClass
As
--
Select
T1.RepoObject_guid
, T1.class
, SysObject_fullname = Max ( T1.SysObject_fullname )
, Min_RowNumber_per_class = Min ( T1.RowNumber_per_Object )
From
sqlparse.RepoObject_SqlModules_20_statement_children As T1
Group By
T1.RepoObject_guid
, T1.class