Red Hat Training

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

8.4. Table Metadata

SYS.Tables
This table supplies information about all the groups (tables, views and documents) in the virtual database.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
Name
string
Short group name
Type
string
Table type (Table, View, Document, ...)
NameInSource
string
Name of this group in the source
IsPhysical
boolean
True if this is a source table
SupportsUpdates
boolean
True if group can be updated
UID
string
Group unique ID
OID
integer
Unique ID
Cardinality
integer
Approximate number of rows in the group
Description
string
Description
IsSystem
boolean
True if in system table
IsMaterialized
boolean
True if materialized.
SYS.Columns
This table supplies information about all the elements (columns, tags, attributes, etc) in the virtual database.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
TableName
string
Table name
Name
string
Element name (not qualified)
Position
integer
Position in group (1-based)
NameInSource
string
Name of element in source
DataType
string
Data Virtualization runtime data type name
Scale
integer
Number of digits after the decimal point
ElementLength
integer
Element length (mostly used for strings)
sLengthFixed
boolean
Whether the length is fixed or variable
SupportsSelect
boolean
Element can be used in SELECT
SupportsUpdates
boolean
Values can be inserted or updated in the element
IsCaseSensitive
boolean
Element is case-sensitive
IsSigned
boolean
Element is signed numeric value
IsCurrency
boolean
Element represents monetary value
IsAutoIncremented
boolean
Element is auto-incremented in the source
NullType
string
Nullability: "Nullable", "No Nulls", "Unknown"
MinRange
string
Minimum value
MaxRange
string
Maximum value
DistinctCount
integer
Distinct value count, -1 can indicate unknown
NullCount
integer
Null value count, -1 can indicate unknown
SearchType
string
Searchability: "Searchable", "All Except Like", "Like Only", "Unsearchable"
Format
string
Format of string value
DefaultValue
string
Default value
JavaClass
string
Java class that will be returned
Precision
integer
Number of digits in numeric value
CharOctetLength
integer
Measure of return value size
Radix
integer
Radix for numeric values
GroupUpperName
string
Upper-case full group name
UpperName
string
Upper-case element name
UID
string
Element unique ID
OID
integer
Unique ID
Description
string
Description
SYS.Keys
This table supplies information about primary, foreign, and unique keys.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
Table Name
string
Table name
Name
string
Key name
Description
string
Description
NameInSource
string
Name of key in source system
Type
string
Type of key: "Primary", "Foreign", "Unique", etc
IsIndexed
boolean
True if key is indexed
RefKeyUID
string
Referenced key UID (if foreign key)
UID
string
Key unique ID
OID
integer
Unique ID
TableUID
string
-
RefTableUID
string
-
ColPositions
short[]
-
SYS.KeyColumns
This table supplies information about the columns referenced by a key.
Column Name
Type
Description
VDBName
string
VDB name
SchemaName
string
Schema Name
TableName
string
Table name
Name
string
Element name
KeyName
string
Key name
KeyType
string
Key type: "Primary", "Foreign", "Unique", etc
RefKeyUID
string
Referenced key UID
UID
string
Key UID
OID
integer
Unique ID
Position
integer
Position in key

Warning

The OID column is no longer used on system tables. Use UID instead.
SYS.Spatial_Sys_Ref
Here are the attributes for this table:
Column Name
Type
Description
srid
integer
Spatial Reference Identifier
auth_name
string
Name of the standard or standards body.
auth_srid
integer
SRID for the auth_name authority.
srtext
string
Well-Known Text representation
proj4text
string
For use with the Proj4 library.
SYS.Geometry_Columns
Here are the attributes for this table:
Column Name
Type
Description
F_TABLE_CATALOG
string
catalog name
F_TABLE_SCHEMA
string
schema name
F_TABLE_NAME
string
table name
F_GEOMETRY_COLUMN
string
column name
COORD_DIMENSION
integer
Number of coordinate dimensions
SRID
integer
Spatial Reference Identifier
TYPE
string
Geometry type name

Note

The coord_dimension and srid properties are determined from the coord_dimension and the srid extension properties on the column. When possible, these values are set automatically by the relevant importer. If they are not set, they are reported as 2 and 0 respectively. If client logic expects actual values, then you may need to set them manually.