Red Hat Training

A Red Hat training course is available for Red Hat JBoss Data Virtualization

8.2. VDB Metadata

SYSADMIN.VDBResources
This table provides the current VDB contents.
Column Name
Type
Description
resourcePath
string
The path to the contents.
contents
blob
The contents as a blob.
SYS.VirtualDatabases
This table supplies information about the currently connected virtual database, of which there is always exactly one (in the context of a connection).
Column Name
Type
Description
Name
string
The name of the VDB
Version
string
The version of the VDB
SYS.Schemas
This table supplies information about all the schemas in the virtual database, including the system schema itself (System).
Column Name
Type
Description
VDBName
string
VDB name
Name
string
Schema name
IsPhysical
boolean
True if this represents a source
UID
string
Unique ID
OID
integer
Unique ID
Description
string
Description
PrimaryMetamodelURI
string
URI for the primary metamodel describing the model used for this schema
SYS.Properties
This table supplies user-defined properties on all objects based on metamodel extensions. Normally, this table is empty if no metamodel extensions are being used.
Column Name
Type
Description
Name
string
Extension property name
Value
string
Extension property value
UID
string
Key unique ID
OID
integer
Unique ID

Warning

The OID column is no longer used on system tables. Use UID instead.