sqlparse.RepoObject_SqlModules_31_object - V

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

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

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_31_object

Columns

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

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

int

NULL

uniqueidentifier

NOT NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_31_object

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_31_object

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_31_object

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_31_object

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_31_object

Indexes

idx_RepoObject_SqlModules_31_object__1

Column Details

_

is_1_create

is_1_create

int

NULL

is_2_view

is_2_view

int

NULL

is_3_Identifier

is_3_Identifier

int

NULL

is_4_as

is_4_as

int

NULL

is_5_select

is_5_select

int

NULL

is_6_Identifier

is_6_Identifier

int

NULL

is_6_IdentifierList

is_6_IdentifierList

int

NULL

is_7_from

is_7_from

int

NULL

is_7_IdentifierList

is_7_IdentifierList

int

NULL

is_8_IdentifierList

is_8_IdentifierList

int

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

sqlparse.RepoObject_SqlModules_31_object - V script
CREATE View sqlparse.RepoObject_SqlModules_31_object
As
--
Select
    RepoObject_guid
  , SysObject_fullname  = Max ( SysObject_fullname )
  , is_1_create         = Max ( is_1_create )
  , is_2_view           = Max ( is_2_view )
  , is_3_Identifier     = Max ( is_3_Identifier )
  , is_4_as             = Max ( is_4_as )
  , is_5_select         = Max ( is_5_select )
  , is_6_Identifier     = Max ( is_6_Identifier )
  , is_6_IdentifierList = Max ( is_6_IdentifierList )
  , is_7_from           = Max ( is_7_from )
  , is_7_IdentifierList = Max ( is_7_IdentifierList )
  , is_8_IdentifierList = Max ( is_8_IdentifierList )
From
    sqlparse.RepoObject_SqlModules_21_statement_children_helper
Group By
    RepoObject_guid