# default column-remarks# SYSTEM_ALIASESSYSTEM_ALIASES_OBJECT_TYPE=type of the aliased object: "DOMAIN" for data type aliases and "ROUTINE" for routine call aliasesSYSTEM_ALIASES_OBJECT_CAT=catalog in which the aliased object is definedSYSTEM_ALIASES_OBJECT_SCHEM=schema in which the aliased object is definedSYSTEM_ALIASES_OBJECT_NAME=simple identifier of the aliased objectSYSTEM_ALIASES_ALIAS_CAT=catalog in which the alias is definedSYSTEM_ALIASES_ALIAS_SCHEM=schema in which the alias is definedSYSTEM_ALIASES_ALIAS=the SQL identifier which is the alias for the indicated object# SYSTEM_ALLTYPEINFOSYSTEM_ALLTYPEINFO_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.SYSTEM_ALLTYPEINFO_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).SYSTEM_ALLTYPEINFO_PRECISION=The maximum column size for this data type.  For numeric data, this is the maximum precision.  For string data, this is the length in characters.  For datetime data types, this is the length in characters of the string representation (assuming the maximum allowed precision of the fractional seconds component).  NULL for data types where column size is not applicable.  For interval data types, this is the number of characters in the character representation of the interval literal (as defined by the interval leading precision).SYSTEM_ALLTYPEINFO_LITERAL_PREFIX=the character or characters used to prefix a literal of this type; for example, a single quotation mark (') for character data types; NULL for data types where a literal prefix is not applicableSYSTEM_ALLTYPEINFO_LITERAL_SUFFIX=the character or characters used to terminate a literal of this type; for example, a single quotation mark (') for character data types; NULL for data types where a literal suffix is not applicableSYSTEM_ALLTYPEINFO_CREATE_PARAMS=A list of keywords, separated by commas, corresponding to each parameter that may be specified in parentheses when issuing DDL relative to the data type.  The keywords in the list, in the language of the current Locale, may be any of the following:  length, precision, scale.  They appear in the order that the syntax requires that they be used.  For example, CREATE_PARAMS for DECIMAL with an English locale would be "precision,scale"; CREATE_PARAMS for VARCHAR would be "length".  The value is NULL if there are no parameters for the data type definition; for example, INTEGER.SYSTEM_ALLTYPEINFO_NULLABLE=NULL values allowed for this type?: { No Nulls | Nullable | Unknown }SYSTEM_ALLTYPEINFO_CASE_SENSITIVE=TRUE if the type is case-sensitive in collations and comparisons; FALSE otherwiseSYSTEM_ALLTYPEINFO_SEARCHABLE=use of WHERE?: { None | Char (Only WHERE .. LIKE) | Basic (Except WHERE .. LIKE) | Searchable (All forms of WHERE...) }SYSTEM_ALLTYPEINFO_UNSIGNED_ATTRIBUTE=TRUE if the data type is unsigned; NULL the attribute is not applicable to the data type or the data type is not numeric.SYSTEM_ALLTYPEINFO_FIXED_PREC_SCALE=TRUE if the data type has predefined fixed precision and scale , like a money data type.  NULL for non-numeric types.SYSTEM_ALLTYPEINFO_AUTO_INCREMENT=NULL if the attribute is not applicable to the data type or the data type is not numeric.  If TRUE, this indicates that when an insert is made, a unique value is inserted into the column at insert time. The increment is not defined. An application should not assume that auto-increment values start at any particular point or increment by any particular value.SYSTEM_ALLTYPEINFO_LOCAL_TYPE_NAME=Localized version of the name of the data type; NULL if a localized name is not supported.  This name is intended for display only, such as in dialog boxesSYSTEM_ALLTYPEINFO_MINIMUM_SCALE=minimum scale supportedSYSTEM_ALLTYPEINFO_MAXIMUM_SCALE=maximum scale supportedSYSTEM_ALLTYPEINFO_SQL_DATA_TYPE=The value of the SQL data type as it would appear in the SQL CLI SQL_DESC_TYPE field of the SQLDA.SYSTEM_ALLTYPEINFO_SQL_DATETIME_SUB=When the value of SQL_DATA_TYPE is SQL_DATETIME or SQL_INTERVAL, this column contains the datetime/interval subcode.  For data types other than datetime and interval, this column is NULL.SYSTEM_ALLTYPEINFO_NUM_PREC_RADIX=For numeric types, this column contains the value 10 to indicate that COLUMN_SIZE specifies a number of decimal digits.  Otherwise, this column is NULL.SYSTEM_ALLTYPEINFO_INTERVAL_PRECISION=If the data type is an interval data type, then this column contains the value of the interval leading precision.  Otherwise, this column is NULL.SYSTEM_ALLTYPEINFO_AS_TAB_COL=TRUE if the engine supports this data type as a table column, else FALSESYSTEM_ALLTYPEINFO_AS_PROC_COL=TRUE if the engine supports this data type as a procedure parameter or return type, else FALSESYSTEM_ALLTYPEINFO_MAX_PREC_ACT=same as PRECISION except for data types whose precision cannot be represented by an INTEGER column valueSYSTEM_ALLTYPEINFO_MIN_SCALE_ACT=same as MINIMUM_SCALE except for data types whose minimum scale cannot be represented by a SMALLINT column valueSYSTEM_ALLTYPEINFO_MAX_SCALE_ACT=same as MAXIMUM_SCALE except for data types whose maximum scale cannot be represented by a SMALLINT column valueSYSTEM_ALLTYPEINFO_COL_ST_CLS_NAME=the fully qualified name of the Java class that HSQLDB uses to represent values of this type in memorySYSTEM_ALLTYPEINFO_COL_ST_IS_SUP=TRUE if the Java class that HSQLDB uses to represent values of this type in memory is supported under the hosting JVM and engine build optionsSYSTEM_ALLTYPEINFO_STD_MAP_CLS_NAME=the fully qualified name of the Java class that the JDBC standard mapping uses to represent values of this typeSYSTEM_ALLTYPEINFO_STD_MAP_IS_SUP=TRUE if the Java class that the JDBC standard mapping uses to represent values of this type is supported under the current JVMSYSTEM_ALLTYPEINFO_CST_MAP_CLS_NAME=the fully qualified name of the Java class that HSQLDB provides to represent values of this type via the JDBC interfaceSYSTEM_ALLTYPEINFO_CST_MAP_IS_SUP=TRUE if the Java class that HSQLDB provides to represent values of this type via the JDBC interface is supported under the hosting JVM and engine build optionsSYSTEM_ALLTYPEINFO_MCOL_JDBC=the maximum character octet length of this type if it is representable via the JDBC interface (i.e. as an INTEGER column value)SYSTEM_ALLTYPEINFO_MCOL_ACT=same as MCOL_JDBC except for data types whose maximum character octet length cannot be represented by an INTEGER column valueSYSTEM_ALLTYPEINFO_DEF_OR_FIXED_SCALE=the default or fixed scale of numeric types; NULL if not applicable of the type is not numericSYSTEM_ALLTYPEINFO_REMARKS=a localized explanatory comment on the data typeSYSTEM_ALLTYPEINFO_TYPE_SUB=the variant tag for this variation of the data type.  1 = standard, 2 = identity, 4 = ignore case# SYSTEM_BESTROWIDENTIFIERSYSTEM_BESTROWIDENTIFIER_SCOPE=actual scope of result, as defined in java.sql.DatabaseMetadataSYSTEM_BESTROWIDENTIFIER_COLUMN_NAME=simple column nameSYSTEM_BESTROWIDENTIFIER_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).SYSTEM_BESTROWIDENTIFIER_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.SYSTEM_BESTROWIDENTIFIER_COLUMN_SIZE=precision for number types; length for variable sized types; NULL for othersSYSTEM_BESTROWIDENTIFIER_BUFFER_LENGTH=The maximum length in bytes of data, if definitely known, that would be transferred to a buffer on a fetch operation.  For numeric data, this size may be different than the size of the data stored on the data source.  This value is the same as the COLUMN_SIZE column for binary data. This value is the twice the COLUMN_SIZE column for character data.  If the actual value is larger than can be represented in an INTEGER column value, this is NULL.SYSTEM_BESTROWIDENTIFIER_DECIMAL_DIGITS=scale of column for number typesSYSTEM_BESTROWIDENTIFIER_PSEUDO_COLUMN=is this a pseudo column like an Oracle ROWID?SYSTEM_BESTROWIDENTIFIER_TABLE_CAT=catalog in which the table containing the column is definedSYSTEM_BESTROWIDENTIFIER_TABLE_SCHEM=schema in which the table containing the column is definedSYSTEM_BESTROWIDENTIFIER_TABLE_NAME=simple name of the table containing the columnSYSTEM_BESTROWIDENTIFIER_NULLABLE=is the column nullable?SYSTEM_BESTROWIDENTIFIER_IN_KEY=does column participate in primary or alternate key?# SYSTEM_BYTECODESYSTEM_BYTECODE_OBJECT_CAT=catalog in which the executable object is definedSYSTEM_BYTECODE_OBJECT_SCHEM=schema in which the executable object is definedSYSTEM_BYTECODE_OBJECT_NAME=simple name of executable objectSYSTEM_BYTECODE_OBJECT_TYPE=type of executable objectSYSTEM_BYTECODE_SIGNATURE=Java method signature of executable objectSYSTEM_BYTECODE_LINE=instruction line numberSYSTEM_BYTECODE_PC=instruction program counterSYSTEM_BYTECODE_OPCODE=instruction opcodeSYSTEM_BYTECODE_MNEMONIC=instruction mnemonicSYSTEM_BYTECODE_OPERANDS=instruction operandsSYSTEM_BYTECODE_OPERANDS_DESCRIPTION=a human-readable description of instruction operandsSYSTEM_BYTECODE_INSTRUCTION_DESCRIPTION=a human-readable description of whole instruction# SYSTEM_CACHEINFO#SYSTEM_CACHEINFO_CACHE_CLASS=FQN of the Java Class implementing the cache#SYSTEM_CACHEINFO_CACHE_HASH=the in-memory hashCode() of the Cache objectSYSTEM_CACHEINFO_CACHE_FILE=absolute path of the file underlying the cache object#SYSTEM_CACHEINFO_CACHE_LENGTH=length of the cache object's row data arraySYSTEM_CACHEINFO_MAX_CACHE_COUNT=maximum number of rows that will be buffered in memory by this cacheSYSTEM_CACHEINFO_MAX_CACHE_BYTES=approximate maximum size, in bytes, of row data that will be buffered in memory by this cacheSYSTEM_CACHEINFO_CACHE_SIZE=number of rows currently cachedSYSTEM_CACHEINFO_CACHE_BYTES=approximate number of row data bytes currently cachedSYSTEM_CACHEINFO_FILE_FREE_BYTES=aggregate size, in octets, of all allocation units considered available for reuse#SYSTEM_CACHEINFO_SMALLEST_FREE_ITEM=size, in octets, of smallest allocation unit available for reuse#SYSTEM_CACHEINFO_LARGEST_FREE_ITEM=size, in octets, of largest allocation unit available for reuseSYSTEM_CACHEINFO_FILE_FREE_COUNT=number of allocation units available for reuseSYSTEM_CACHEINFO_FILE_FREE_POS=one greater than largest file position known to be allocated#SYSTEM_CACHEINFO_MAX_CACHE_SIZE=maximum allowable number of cached Row objects#SYSTEM_CACHEINFO_MAX_CACHE_BYTE_SIZE=limit on memory consumption of cached Row objects#SYSTEM_CACHEINFO_MULTIPLIER_MASK=binary mask used to calculate indices into row data array#SYSTEM_CACHEINFO_WRITER_LENGTH=length of row write buffer array# SYSTEM_CATALOGSSYSTEM_CATALOGS_TABLE_CAT=catalog name# SYSTEM_CLASSPRIVILEGESSYSTEM_CLASSPRIVILEGES_CLASS_CAT=catalog in which the class is definedSYSTEM_CLASSPRIVILEGES_CLASS_SCHEM=schema in which the class is definedSYSTEM_CLASSPRIVILEGES_CLASS_NAME=fully qualified name of classSYSTEM_CLASSPRIVILEGES_GRANTOR=grantor of accessSYSTEM_CLASSPRIVILEGES_GRANTEE=grantee of accessSYSTEM_CLASSPRIVILEGES_PRIVILEGE=name of access, e.g. one of { "EXECUTE" (callable routines) | "FIRE" (fireable trigger body implementations)}SYSTEM_CLASSPRIVILEGES_IS_GRANTABLE=grantable?: "YES" - may grant to others, "NO" - not permitted to grant to others, NULL - unknown# SYSTEM_COLUMNPRIVILEGESSYSTEM_COLUMNPRIVILEGES_TABLE_CAT=catalog in which the table containing the column is definedSYSTEM_COLUMNPRIVILEGES_TABLE_SCHEM=schema in which the table containing the column is definedSYSTEM_COLUMNPRIVILEGES_TABLE_NAME=simple name of the table containing the column is definedSYSTEM_COLUMNPRIVILEGES_COLUMN_NAME=simple name of the columnSYSTEM_COLUMNPRIVILEGES_GRANTOR=grantor of accessSYSTEM_COLUMNPRIVILEGES_GRANTEE=grantee of accessSYSTEM_COLUMNPRIVILEGES_PRIVILEGE=name of access, e.g. one of { ALL, SELECT, INSERT, UPDATE, DELETE, ...}SYSTEM_COLUMNPRIVILEGES_IS_GRANTABLE=grantable?: YES - may grant to others, NO - not permitted to grant to others, NULL - unknown# SYSTEM_COLUMNSSYSTEM_COLUMNS_TABLE_CAT=catalog in which the table containing the column is definedSYSTEM_COLUMNS_TABLE_SCHEM=schema in which the table containing the column is definedSYSTEM_COLUMNS_TABLE_NAME=simple name of the table containing the columnSYSTEM_COLUMNS_COLUMN_NAME=simple name of the columnSYSTEM_COLUMNS_DATA_TYPE=SQL data type.  This may be a java.sql.Types data type, a SQL 200n data type or an HSQLDB-specific data type.  For datetime or interval data types, this column returns the concise data type (such as SQL_璗YPE_璗IME or SQL_璉NTERVAL_璝EAR_璗O_璏ONTH).SYSTEM_COLUMNS_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.SYSTEM_COLUMNS_COLUMN_SIZE=precision for number types; length for sized types; NULL if not applicableSYSTEM_COLUMNS_BUFFER_LENGTH=The maximum length in bytes of data, if definitely known, that would be transferred to a buffer on a fetch operation.  For numeric data, this size may be different than the size of the data stored on the data source.  This value is the same as the COLUMN_SIZE column for binary data. This value is the twice the COLUMN_SIZE column for character data.  If the actual value is larger than can be represented in an INTEGER column value, this is NULL.SYSTEM_COLUMNS_DECIMAL_DIGITS=# of fractional digits (scale) for number typesSYSTEM_COLUMNS_NUM_PREC_RADIX=Radix of reported numeric precision (i.e. base of number types)SYSTEM_COLUMNS_NULLABLE=is NULL allowed?: { columnNoNulls (maybe not), columnNullable (definitely), columnNullableUnknown }SYSTEM_COLUMNS_REMARKS=explanitory comment describing the column (may be NULL)SYSTEM_COLUMNS_COLUMN_DEF=default value (may be NULL)SYSTEM_COLUMNS_SQL_DATA_TYPE=The value of the SQL data type as it would appear in the SQL CLI SQL_DESC_TYPE field of the SQLDA.SYSTEM_COLUMNS_SQL_DATETIME_SUB=When the value of SQL_DATA_TYPE is SQL_DATETIME or SQL_INTERVAL, this column contains the datetime/interval subcode.  For data types other than datetime and interval, this column is NULL.SYSTEM_COLUMNS_CHAR_OCTET_LENGTH=for char types, the maximum number of bytes in the column, if the value can be represented as an INTEGER column value, else NULLSYSTEM_COLUMNS_ORDINAL_POSITION=index of column in table (starting at 1)SYSTEM_COLUMNS_IS_NULLABLE=is column nullable?: { YES (might allow) | NO (definitely not)  | '' (unknown) }SYSTEM_COLUMNS_SCOPE_CATLOG=catalog of table that is the scope of a reference attribute (NULL if DATA_TYPE isn't REF)SYSTEM_COLUMNS_SCOPE_SCHEMA=schema of table that is the scope of a reference attribute (NULL if the DATA_TYPE isn't REF)SYSTEM_COLUMNS_SCOPE_TABLE=table name that this the scope of a reference attribute (NULL if the DATA_TYPE isn't REF)SYSTEM_COLUMNS_SOURCE_DATA_TYPE=source type of a distinct type or user-generated Ref type, SQL type from DITypes (NULL if DATA_TYPE isn't DISTINCT or user-generated REF)SYSTEM_COLUMNS_TYPE_SUB=the HSQLDB-specific type subidentifier (1:default, 2:identity, 4:ignorecase)# SYSTEM_CROSSREFERENCESYSTEM_CROSSREFERENCE_PKTABLE_CAT=the catalog in which the referenced table is definedSYSTEM_CROSSREFERENCE_PKTABLE_SCHEM=the schema in which the referenced table is definedSYSTEM_CROSSREFERENCE_PKTABLE_NAME=simple name of the referenced tableSYSTEM_CROSSREFERENCE_PKCOLUMN_NAME=simple name of the referenced columnSYSTEM_CROSSREFERENCE_FKTABLE_CAT=the catalog in which the referencing table is definedSYSTEM_CROSSREFERENCE_FKTABLE_SCHEM=the schema in which the referencing table is definedSYSTEM_CROSSREFERENCE_FKTABLE_NAME=the simple name of the referencing tableSYSTEM_CROSSREFERENCE_FKCOLUMN_NAME=the simple name of the referencing columnSYSTEM_CROSSREFERENCE_KEY_SEQ=sequence number within foreign key definitionSYSTEM_CROSSREFERENCE_UPDATE_RULE=how does an update of referenced row columns affect referencing rows?: e.g. { Cascade | Set Null | Set Default | Restrict (No Action) }SYSTEM_CROSSREFERENCE_DELETE_RULE=how does deletion of a referenced row affect referencing rows?: e.g. { Cascade | Set Null | Set Default | Restrict (No Action) }SYSTEM_CROSSREFERENCE_FK_NAME=the name of the foreign keySYSTEM_CROSSREFERENCE_PK_NAME=the name of the referenced column set (usually the name of a primary key constraint, but may be a unique constraint or even the name of a non-unique index previous to 1.7.0)SYSTEM_CROSSREFERENCE_DEFERRABILITY=foreign key constraints deferred until commit?: e.g. { initially deferred | initially immediate | not deferrable }# SYSTEM_INDEXINFOSYSTEM_INDEXINFO_TABLE_CAT=catalog in which the table using the index is definedSYSTEM_INDEXINFO_TABLE_SCHEM=schema in which the table using the index is definedSYSTEM_INDEXINFO_TABLE_NAME=simple name of the table using the indexSYSTEM_INDEXINFO_NON_UNIQUE=can index values be non-unique?SYSTEM_INDEXINFO_INDEX_QUALIFIER=catalog in which the index is definedSYSTEM_INDEXINFO_INDEX_NAME=simple name of the indexSYSTEM_INDEXINFO_TYPE=index type: e.g. { Clustered | Hashed | Other }SYSTEM_INDEXINFO_ORDINAL_POSITION=column sequence number within indexSYSTEM_INDEXINFO_COLUMN_NAME=simple column nameSYSTEM_INDEXINFO_ASC_OR_DESC=column sort sequence: e.g. { "A" (Ascending) | "D" (Descending) }SYSTEM_INDEXINFO_CARDINALITY=index cardinality: # of unique values in the index (currently unused)SYSTEM_INDEXINFO_PAGES=index page use (currently unused)SYSTEM_INDEXINFO_FILTER_CONDITION=filter condition, if any (currently unused)