sqlparse.RepoObject_SqlModules_10_statement - V

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

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

Description

Examples

Entity Diagram

entity-sqlparse.repoobject_sqlmodules_10_statement

Columns

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

nvarchar(max)

NULL

nvarchar(500)

NULL

bit

NULL

bit

NULL

bit

NULL

nvarchar(max)

NULL

uniqueidentifier

NOT NULL

nvarchar(max)

NULL

nvarchar(261)

NULL

Foreign Key Diagram

entity_1_1_fk-sqlparse.repoobject_sqlmodules_10_statement

References

Object Reference Diagram - 1 1

entity_1_1_objectref-sqlparse.repoobject_sqlmodules_10_statement

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-sqlparse.repoobject_sqlmodules_10_statement

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-sqlparse.repoobject_sqlmodules_10_statement

Column Reference Diagram

entity_1_1_colref-sqlparse.repoobject_sqlmodules_10_statement

Indexes

idx_RepoObject_SqlModules_10_statement__1

Column Details

_

children

children

nvarchar(max)

NULL

class

class

nvarchar(500)

NULL

is_group

is_group

bit

NULL

is_keyword

is_keyword

bit

NULL

is_whitespace

is_whitespace

bit

NULL

normalized

normalized

nvarchar(max)

NULL

RepoObject_guid

RepoObject_guid

uniqueidentifier

NOT NULL

sql_modules_json

sql_modules_json

nvarchar(max)

NULL

SysObject_fullname

SysObject_fullname

nvarchar(261)

NULL

Description

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


sql_modules_definition

sqlparse.RepoObject_SqlModules_10_statement - V script
/*extract class Statement, it should be the one and only node on first level*/
CREATE View sqlparse.RepoObject_SqlModules_10_statement
As
--
Select
    T1.RepoObject_guid
  , ro.SysObject_fullname
  , T1.sql_modules_json
  , j2.*
From
    sqlparse.RepoObject_SqlModules As T1
    Cross Apply
    OpenJson ( T1.sql_modules_json )
    With
    (
        class NVarchar ( 500 ) N'$.class'
      , is_group Bit N'$.is_group'
      , is_keyword Bit N'$.is_keyword'
      , is_whitespace Bit N'$.is_whitespace'
      , normalized NVarchar ( Max ) N'$.normalized'
      , children NVarchar ( Max ) N'$.children' As Json
    )                              As j2
    Left Join
        repo.RepoObject As ro
            On
            ro.RepoObject_guid = T1.RepoObject_guid
Where
    T1.is_json_sql_modules_json = 1
    And j2.class                = 'Statement'