dbeaver.DataSources_DbSchemaTable_FK - V
type: V ( view ), modify_date: 2021-08-17 18:49:49
RepoObject_guid: 99BE898F-9381-EB11-84E9-A81E8446D5B0
Columns
PK | Column Name | Data Type | NULL? | ID |
---|---|---|---|---|
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
|||
|
|
Column Details
_
sql_modules_definition
dbeaver.DataSources_DbSchemaTable_FK - V script
CREATE View dbeaver.DataSources_DbSchemaTable_FK
As
Select
--
t1.id
, t1.BulkColumn
, t1.is_json
, t1.VirtualModels
, t1.VirtualModel_key
, t1.VirtualModel_json
, t1.VirtualModel_database
, t1.VirtualModel_database_json
, t1.VirtualModel_schema
, t1.VirtualModel_schema_json
, t1.VirtualModel_table
, t1.VirtualModel_table_json
--, [VirtualModel_table_constraints_json]
, t1.VirtualModel_table_FK_json
--,[VirtualModel_table_properties_json]
, j1.*
, j2.*
From
dbeaver.DataSources_DbSchemaTable As t1
Cross Apply OpenJson ( t1.VirtualModel_table_FK_json ) As j1
Cross Apply
OpenJson ( j1.Value )
With
(
VirtualModel_table_FK_entity NVarchar ( 500 ) N'$.entity'
, VirtualModel_table_FK_constraint NVarchar ( 500 ) N'$.constraint'
, VirtualModel_table_FK_attributes_json NVarchar ( Max ) N'$.attributes' As Json
) As j2