sqlparse.RepoObject_SqlModules_33_ObjectNormalized - V

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

RepoObject_guid: 0090291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_33_objectnormalized

Columns

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

1

uniqueidentifier

NOT NULL

2

nvarchar(max)

NULL

bigint

NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_33_objectnormalized

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_33_objectnormalized

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_33_objectnormalized

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_33_objectnormalized

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_33_objectnormalized

Indexes

PK_RepoObject_SqlModules_33_ObjectNormalized

idx_RepoObject_SqlModules_33_ObjectNormalized__2

Column Details

_

RepoObject_guid

1

RepoObject_guid

uniqueidentifier

NOT NULL

normalized

2

normalized

nvarchar(max)

NULL

Min_RowNumber_per_normalized

Min_RowNumber_per_normalized

bigint

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

sqlparse.RepoObject_SqlModules_33_ObjectNormalized - V script
CREATE View sqlparse.RepoObject_SqlModules_33_ObjectNormalized
As
--
Select
    T1.RepoObject_guid
  , T1.normalized
  , SysObject_fullname           = Max ( T1.SysObject_fullname )
  , Min_RowNumber_per_normalized = Min ( T1.RowNumber_per_Object )
From
    sqlparse.RepoObject_SqlModules_20_statement_children As T1
Group By
    T1.RepoObject_guid
  , T1.normalized