sqlparse.RepoObject_SqlModules_32_ObjectClass - V

type: V ( view ), modify_date: 2021-08-17 20:11:29

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

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_32_objectclass

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(500)

NULL

bigint

NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_32_objectclass

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_32_objectclass

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_32_objectclass

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_32_objectclass

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_32_objectclass

Indexes

PK_RepoObject_SqlModules_32_ObjectClass

idx_RepoObject_SqlModules_32_ObjectClass__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

class

2

class

nvarchar(500)

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

(concat('[',[SysObject_schema_name],'].[',[SysObject_name],']'))


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