Red Hat Training

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

8.3. Table Metadata

SYS.Tables
This table supplies information about all the groups (tables, views, documents, etc) 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
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
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.