-
Language:
English
-
Language:
English
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 NameTypeDescriptionVDBNamestringVDB nameSchemaNamestringSchema NameNamestringShort group nameTypestringTable type (Table, View, Document, ...)NameInSourcestringName of this group in the sourceIsPhysicalbooleanTrue if this is a source tableSupportsUpdatesbooleanTrue if group can be updatedUIDstringGroup unique IDOIDintegerUnique IDCardinalityintegerApproximate number of rows in the groupDescriptionstringDescriptionIsSystembooleanTrue if in system tableIsMaterializedbooleanTrue if materialized.
- SYS.Columns
- This table supplies information about all the elements (columns, tags, attributes, etc) in the virtual database.Column NameTypeDescriptionVDBNamestringVDB nameSchemaNamestringSchema NameTableNamestringTable nameNamestringElement name (not qualified)PositionintegerPosition in group (1-based)NameInSourcestringName of element in sourceDataTypestringData Virtualization runtime data type nameScaleintegerNumber of digits after the decimal pointElementLengthintegerElement length (mostly used for strings)sLengthFixedbooleanWhether the length is fixed or variableSupportsSelectbooleanElement can be used in SELECTSupportsUpdatesbooleanValues can be inserted or updated in the elementIsCaseSensitivebooleanElement is case-sensitiveIsSignedbooleanElement is signed numeric valueIsCurrencybooleanElement represents monetary valueIsAutoIncrementedbooleanElement is auto-incremented in the sourceNullTypestringNullability: "Nullable", "No Nulls", "Unknown"MinRangestringMinimum valueMaxRangestringMaximum valueDistinctCountintegerDistinct value count, -1 can indicate unknownNullCountintegerNull value count, -1 can indicate unknownSearchTypestringSearchability: "Searchable", "All Except Like", "Like Only", "Unsearchable"FormatstringFormat of string valueDefaultValuestringDefault valueJavaClassstringJava class that will be returnedPrecisionintegerNumber of digits in numeric valueCharOctetLengthintegerMeasure of return value sizeRadixintegerRadix for numeric valuesGroupUpperNamestringUpper-case full group nameUpperNamestringUpper-case element nameUIDstringElement unique IDOIDintegerUnique IDDescriptionstringDescription
- SYS.Keys
- This table supplies information about primary, foreign, and unique keys.Column NameTypeDescriptionVDBNamestringVDB nameSchemaNamestringSchema NameTable NamestringTable nameNamestringKey nameDescriptionstringDescriptionNameInSourcestringName of key in source systemTypestringType of key: "Primary", "Foreign", "Unique", etcIsIndexedbooleanTrue if key is indexedRefKeyUIDstringReferenced key UID (if foreign key)UIDstringKey unique IDOIDintegerUnique IDTableUIDstring-RefTableUIDstring-ColPositionsshort[]-
- SYS.KeyColumns
- This table supplies information about the columns referenced by a key.Column NameTypeDescriptionVDBNamestringVDB nameSchemaNamestringSchema NameTableNamestringTable nameNamestringElement nameKeyNamestringKey nameKeyTypestringKey type: "Primary", "Foreign", "Unique", etcRefKeyUIDstringReferenced key UIDUIDstringKey UIDOIDintegerUnique IDPositionintegerPosition 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 NameTypeDescriptionsridintegerSpatial Reference Identifierauth_namestringName of the standard or standards body.auth_sridintegerSRID for the auth_name authority.srtextstringWell-Known Text representationproj4textstringFor use with the Proj4 library.
- SYS.Geometry_Columns
- Here are the attributes for this table:Column NameTypeDescriptionF_TABLE_CATALOGstringcatalog nameF_TABLE_SCHEMAstringschema nameF_TABLE_NAMEstringtable nameF_GEOMETRY_COLUMNstringcolumn nameCOORD_DIMENSIONintegerNumber of coordinate dimensionsSRIDintegerSpatial Reference IdentifierTYPEstringGeometry 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.