dbeaver.DataSources_DbSchemaTable - V

Description

Examples

Entity Diagram

Columns

Table 1. Columns of dbeaver.DataSources_DbSchemaTable - V
Column Name	Data Type	NULL?
BulkColumn	`varchar(max)`	`NULL`
id	`int`	`NOT NULL`
is_json	`int`	`NULL`
VirtualModel_database	`nvarchar(4000)`	`NOT NULL`
VirtualModel_database_json	`nvarchar(max)`	`NULL`
VirtualModel_json	`nvarchar(max)`	`NULL`
VirtualModel_key	`nvarchar(4000)`	`NOT NULL`
VirtualModel_schema	`nvarchar(4000)`	`NOT NULL`
VirtualModel_schema_json	`nvarchar(max)`	`NULL`
VirtualModel_table	`nvarchar(500)`	`NULL`
VirtualModel_table_constraints_json	`nvarchar(max)`	`NULL`
VirtualModel_table_FK_json	`nvarchar(max)`	`NULL`
VirtualModel_table_json	`nvarchar(max)`	`NULL`
VirtualModel_table_properties_json	`nvarchar(max)`	`NULL`
VirtualModels	`nvarchar(max)`	`NULL`

Foreign Key Diagram

References

Referenced Objects

dbeaver.DataSources - U

Referencing Objects

Object Reference Diagram - 1 1

Object Reference Diagram - Referenced - 30 0

Object Reference Diagram - Referencing - 0 30

Column Reference Diagram

Column Details

_

BulkColumn

varchar(max)

NULL

Referencing Columns

id

int

NOT NULL

Referencing Columns

is_json

int

NULL

Referencing Columns

VirtualModel_database

nvarchar(4000)

NOT NULL

Referencing Columns

VirtualModel_database_json

nvarchar(max)

NULL

Referencing Columns

VirtualModel_json

nvarchar(max)

NULL

Referencing Columns

VirtualModel_key

nvarchar(4000)

NOT NULL

Referencing Columns

VirtualModel_schema

nvarchar(4000)

NOT NULL

Referencing Columns

VirtualModel_schema_json

nvarchar(max)

NULL

Referencing Columns

VirtualModel_table

nvarchar(500)

NULL

Referencing Columns

VirtualModel_table_constraints_json

nvarchar(max)

NULL

Referencing Columns

dbeaver.DataSources_DbSchemaTable_constraint.VirtualModel_table_constraints_json

VirtualModel_table_FK_json

nvarchar(max)

NULL

Referencing Columns

dbeaver.DataSources_DbSchemaTable_FK.VirtualModel_table_FK_json

VirtualModel_table_json

nvarchar(max)

NULL

Referencing Columns

VirtualModel_table_properties_json

nvarchar(max)

NULL

VirtualModels

nvarchar(max)

NULL

Referencing Columns

sql_modules_definition

dbeaver.DataSources_DbSchemaTable - V script

CREATE View dbeaver.DataSources_DbSchemaTable
As
Select
    --
    j1.*
  , j2.*
  , VirtualModel_key           = j3.[Key]
  , VirtualModel_json          = j3.Value
  , VirtualModel_database      = j4.[Key]
  , VirtualModel_database_json = j4.Value
  , VirtualModel_schema        = j5.[Key]
  , VirtualModel_schema_json   = j5.Value
  , VirtualModel_table         = Substring ( j6.[Key], 2, 500 )
  , VirtualModel_table_json    = j6.Value
  , j7.*
From
    dbeaver.DataSources As j1
    Cross Apply
    OpenJson ( j1.BulkColumn )
    With
    (
        VirtualModels NVarchar ( Max ) N'$."virtual-models"' As Json
    )                   As j2
    Cross Apply OpenJson ( j2.VirtualModels ) As j3
    Cross Apply OpenJson ( j3.Value ) As j4
    Cross Apply OpenJson ( j4.Value ) As j5
    Cross Apply OpenJson ( j5.Value ) As j6
    Cross Apply
    OpenJson ( j6.Value )
    With
    (
        VirtualModel_table_constraints_json NVarchar ( Max ) N'$.constraints' As Json
      , VirtualModel_table_FK_json NVarchar ( Max ) N'$."foreign-keys"' As Json
      , VirtualModel_table_properties_json NVarchar ( Max ) N'$.properties' As Json
    ) As j7
Where
    j1.is_json = 1