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.

Commands: