# SYSTEM_LOBSSYSTEM_LOBS_NAME=Java classfile encoded absolute name of a resource ( /dir1/.../dirn/resourcename.ext)SYSTEM_LOBS_CONTENT=binary content of Java class file or resourceSYSTEM_LOBS_CONTENT_TYPE=content type (possibly a mime-type value)SYSTEM_LOBS_MD5=MD5 hash of content (efficiently detects and avoids attempts to reload identical content)SYSTEM_LOBS_CREATED=time at which content was initially loadedSYSTEM_LOBS_MODIFIED=time at which content was last modified# SYSTEM_PRIMARYKEYSSYSTEM_PRIMARYKEYS_TABLE_CAT=catalog in which table containing primary key is definedSYSTEM_PRIMARYKEYS_TABLE_SCHEM=schema in which table containing primary key is definedSYSTEM_PRIMARYKEYS_TABLE_NAME=simple name of table containing primary keySYSTEM_PRIMARYKEYS_COLUMN_NAME=simple name of column participating in primary keySYSTEM_PRIMARYKEYS_KEY_SEQ=sequence number of column within primary keySYSTEM_PRIMARYKEYS_PK_NAME=primary key name# SYSTEM_PROCEDURECOLUMNSSYSTEM_PROCEDURECOLUMNS_PROCEDURE_CAT=catalog in which procedure is definedSYSTEM_PROCEDURECOLUMNS_PROCEDURE_SCHEM=schema in which procedure is definedSYSTEM_PROCEDURECOLUMNS_PROCEDURE_NAME=procedure identifierSYSTEM_PROCEDURECOLUMNS_COLUMN_NAME=( result column | call parameter | return value ) nameSYSTEM_PROCEDURECOLUMNS_COLUMN_TYPE=kind of column/parameter: { Unknown | IN | INOUT | OUT | RETURN | RESULT }SYSTEM_PROCEDURECOLUMNS_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_PROCEDURECOLUMNS_TYPE_NAME=the HSQLDB-specific data type name; for data types supported as table column types, this is the canonical name used in CREATE TABLE and ALTER TABLE statements.SYSTEM_PROCEDURECOLUMNS_PRECISION=precision for number types; max length for sized types; fixed or max length for others if known, or NULL if not applicableSYSTEM_PROCEDURECOLUMNS_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 unknown or is larger than can be represented in an INTEGER column value, this is NULL.SYSTEM_PROCEDURECOLUMNS_SCALE=scale (# of fractional digits) for number typesSYSTEM_PROCEDURECOLUMNS_RADIX=Radix of reported numeric precision (i.e. base of number types)SYSTEM_PROCEDURECOLUMNS_NULLABLE=can column contain NULL: { No Nulls | Nullable | Unknown }?SYSTEM_PROCEDURECOLUMNS_REMARKS=comment describing parameter or result columnSYSTEM_PROCEDURECOLUMNS_SPECIFIC_NAME=typically, (but not limited to) the fully qualified name and signature of the Java method providing the SQL-invoked routine's entry pointSYSTEM_PROCEDURECOLUMNS_SEQ=provides the ability to deliver rows in JDBC DataseMetaData sort contrct order# SYSTEM_PROCEDURESSYSTEM_PROCEDURES_PROCEDURE_CAT=catalog in which procedure is definedSYSTEM_PROCEDURES_PROCEDURE_SCHEM=schema in which procedure is definedSYSTEM_PROCEDURES_PROCEDURE_NAME=procedure identifierSYSTEM_PROCEDURES_REMARKS=explanatory comment on the procedureSYSTEM_PROCEDURES_PROCEDURE_TYPE=kind of procedure: { Unknown | No Result | Returns Result }SYSTEM_PROCEDURES_NUM_INPUT_PARAMS=number of procedure input parametersSYSTEM_PROCEDURES_NUM_OUTPUT_PARAMS=number of procedure output parametersSYSTEM_PROCEDURES_NUM_RESULT_SETS=number of result sets returned by procedure (if any)SYSTEM_PROCEDURES_ORIGIN=how was named procedure introduced to system?: e.g. { BUILTIN | USER CLASS GRANT | ALIAS | TRIGGER | MODULE | ...}SYSTEM_PROCEDURES_SPECIFIC_NAME=typically, (but not limited to) the fully qualified name and signature of the Java method providing the SQL-invoked routine's entry point# SYSTEM_PROPERTIESSYSTEM_PROPERTIES_PROPERTY_SCOPE=the scope of the property, e.g. ( TEMPORARY | TRANSACTION | SESSION | ...}SYSTEM_PROPERTIES_PROPERTY_NAMESPACE=the namespace in which the property is applicable, e.g. ( database.properties | org.hsqldb.Database | java.sql.DatabaseMetaData | ...)SYSTEM_PROPERTIES_PROPERTY_NAME=the name of the propertySYSTEM_PROPERTIES_PROPERTY_VALUE=the current value of the propertySYSTEM_PROPERTIES_PROPERTY_CLASS=the type of the value, e.g. ( int | boolean | java.lang.String | ...)# SYSTEM_SCHEMASSYSTEM_SCHEMAS_TABLE_SCHEM=schema nameSYSTEM_SCHEMAS_TABLE_CATALOG=catalog in which schema is definedSYSTEM_SCHEMAS_IS_DEFAULT=whether the described schema is the default schema# SYSTEM_SESSIONSSYSTEM_SESSIONS_SESSION_ID=session identifierSYSTEM_SESSIONS_CONNECTED=time at which session connected to databaseSYSTEM_SESSIONS_USER_NAME=name of session user, as known to the databaseSYSTEM_SESSIONS_IS_ADMIN=is session user an admin user?SYSTEM_SESSIONS_AUTOCOMMIT=is session in autocommit mode?SYSTEM_SESSIONS_READONLY=is session in read-only mode?SYSTEM_SESSIONS_MAXROWS=what is the session's MAXROWS setting?SYSTEM_SESSIONS_LAST_IDENTITY=what is the last identity value used by this session?SYSTEM_SESSIONS_TRANSACTION_SIZE=how many undo items are there in this session's transaction buffer?#since 1.8.0SYSTEM_SESSIONS_SCHEMA=this session's current default schema# SYSTEM_SESSIONINFOSYSTEM_SESSIONINFO_KEY=KEY: { SESSION_ID | AUTOCOMMIT | USER | CONNECTION_READONLY | DATABASE_READONLY | MAXROWS | DATABASE | IDENTITY ... }SYSTEM_SESSIONINFO_VALUE=VALUE: the value corresponding to the indicated key (see JavaDocs)# SYSTEM_SUPERTABLESSYSTEM_SUPERTABLES_TABLE_CAT=the table's catalogSYSTEM_SUPERTABLES_TABLE_SCHEM=table schemaSYSTEM_SUPERTABLES_TABLE_NAME=table nameSYSTEM_SUPERTABLES_SUPERTABLE_NAME=the direct super table's name# SYSTEM_SUPERTYPESSYSTEM_SUPERTYPES_TYPE_CAT=the UDT's catalogSYSTEM_SUPERTYPES_TYPE_SCHEM=UDT's schemaSYSTEM_SUPERTYPES_TYPE_NAME=type name of the UDTSYSTEM_SUPERTYPES_SUPERTYPE_CAT=the direct super type's catalogSYSTEM_SUPERTYPES_SUPERTYPE_SCHEM=the direct super type's schemaSYSTEM_SUPERTYPES_SUPERTYPE_NAME=the direct super type's name# SYSTEM_TABLEPRIVILEGESSYSTEM_TABLEPRIVILEGES_TABLE_CAT=table catalogSYSTEM_TABLEPRIVILEGES_TABLE_SCHEM=table schemaSYSTEM_TABLEPRIVILEGES_TABLE_NAME=table nameSYSTEM_TABLEPRIVILEGES_GRANTOR=grantor of accessSYSTEM_TABLEPRIVILEGES_GRANTEE=grantee of accessSYSTEM_TABLEPRIVILEGES_PRIVILEGE=name of access: e.g. one of { ALL | SELECT | INSERT | UPDATE | DELETE }SYSTEM_TABLEPRIVILEGES_IS_GRANTABLE=for grantee: YES - may grant to others, NO - may not grant to others, NULL - unknown# SYSTEM_TABLESSYSTEM_TABLES_TABLE_CAT=table catalogSYSTEM_TABLES_TABLE_SCHEM=table schemaSYSTEM_TABLES_TABLE_NAME=table nameSYSTEM_TABLES_TABLE_TYPE=table type: e.g. one of { TABLE | VIEW | SYSTEM TABLE | GLOBAL TEMPORARY ... }SYSTEM_TABLES_REMARKS=explanatory comment on the tableSYSTEM_TABLES_TYPE_CAT=table type catalogSYSTEM_TABLES_TYPE_SCHEM=table type schemaSYSTEM_TABLES_TYPE_NAME=table type nameSYSTEM_TABLES_SELF_REFERENCING_COL_NAME=name of the designated "identifier" column of typed table (null if not typed)SYSTEM_TABLES_REF_GENERATION=how are values in SELF_REFERENCING_COL_NAME created?: e.g. one of { "SYSTEM" | "USER" | "DERIVED" | NULL }SYSTEM_TABLES_HSQLDB_TYPE=the HSQLDB-specific type of the table, e.g. ( MEMORY | CACHED | TEXT | ...)SYSTEM_TABLES_READ_ONLY=TRUE if the table is read-only, else FALSE# SYSTEM_TABLETYPESSYSTEM_TABLETYPES_TABLE_TYPE=table type name# SYSTEM_TEXTTABLESSYSTEM_TEXTTABLES_TABLE_CAT=table catalogSYSTEM_TEXTTABLES_TABLE_SCHEM=table schemaSYSTEM_TEXTTABLES_TABLE_NAME=table nameSYSTEM_TEXTTABLES_DATA_SOURCE_DEFINTION=the "spec" proption of the table's SET TABLE ... SOURCE DDL declarationSYSTEM_TEXTTABLES_FILE_PATH=path to table's text file data sourceSYSTEM_TEXTTABLES_FILE_ENCODING=encoding of table's text file data sourceSYSTEM_TEXTTABLES_FIELD_SEPARATOR=the default field separatorSYSTEM_TEXTTABLES_VARCHAR_SEPARATOR=varchar field separatorSYSTEM_TEXTTABLES_LONGVARCHAR_SEPARATOR=longvarchar field separatorSYSTEM_TEXTTABLES_IS_IGNORE_FIRST=ignores first line of file?# added to reflect 1.7.2 RC1SYSTEM_TEXTTABLES_IS_QUOTED=fields are quoted if necessary?#--SYSTEM_TEXTTABLES_IS_ALL_QUOTED=every field is quoted?SYSTEM_TEXTTABLES_IS_DESC=read rows starting at end of file?# SYSTEM_TRIGGERSSYSTEM_TRIGGERS_TRIGGER_CAT=Trigger catalogSYSTEM_TRIGGERS_TRIGGER_SCHEM=Trigger SchemaSYSTEM_TRIGGERS_TRIGGER_NAME=Trigger NameSYSTEM_TRIGGERS_TRIGGER_TYPE=When the trigger fires: { BEFORE STATEMENT | BEFORE EACH ROW | BEFORE EVENT | AFTER STATEMENT | AFTER EACH ROW | AFTER EVENT }SYSTEM_TRIGGERS_TRIGGERING_EVENT=Events that fire the trigger: { INSERT | UPDATE | DELETE | STARTUP | SHUTDOWN | ERROR | LOGON | LOGOFF | CREATE | ALTER | DROP }SYSTEM_TRIGGERS_TABLE_CAT=Catalog of the table on which the trigger is definedSYSTEM_TRIGGERS_TABLE_SCHEM=for BASE_OBJECT_TYPE = TABLE or VIEW: the schema on which the trigger is defined (May be NULL); For BASE_OBJECT_TYPE = SCHEMA: USER for which CREATE, ALTER, DROP, or SET statement fires trigger; For BASE_OBJECT_TYPE = DATABASE, NULLSYSTEM_TRIGGERS_BASE_OBJECT_TYPE=The base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASESYSTEM_TRIGGERS_TABLE_NAME=If the base object type of the trigger is SCHEMA or DATABASE, then this column is NULL; if the base object type of the trigger is TABLE or VIEW, this columns indicates the table/view name on which the trigger is definedSYSTEM_TRIGGERS_COLUMN_NAME=Name of the nested table column (if nested table trigger), else NULLSYSTEM_TRIGGERS_REFERENCING_NAMES=Names used for referencing column values from within the trigger (e.g. row, old, new, etc. -- May be NULL for no parameter call-type triggers)SYSTEM_TRIGGERS_WHEN_CLAUSE=Must evaluate to TRUE for TRIGGER_BODY to execute (NULL is considered same as no WHERE clause, i.e. always TRUE)SYSTEM_TRIGGERS_STATUS=Whether the trigger is enabled: e.g. one of { "ENABLED" | "DISABLED" }SYSTEM_TRIGGERS_DESCRIPTION=Trigger description. May be NULL but in most cases is the original trigger DDLSYSTEM_TRIGGERS_ACTION_TYPE=The action type of the trigger body: "CALL" or embedded language name (e.g. "JavaScript", "Prolog", "SQLJ", "PL/SQL" "PL1", etc.)SYSTEM_TRIGGERS_TRIGGER_BODY=Statement(s) (possibly in embedded language) executed by the trigger when it fires; usually of the form 'CALL "package.class"'# SYSTEM_TRIGGERCOLUMNSSYSTEM_TRIGGERCOLUMNS_TRIGGER_CAT=Trigger catalogSYSTEM_TRIGGERCOLUMNS_TRIGGER_SCHEM=Trigger schemaSYSTEM_TRIGGERCOLUMNS_TRIGGER_NAME=Trigger nameSYSTEM_TRIGGERCOLUMNS_TABLE_CAT=Catalog of the table on which the trigger is defined (May be NULL)SYSTEM_TRIGGERCOLUMNS_TABLE_SCHEM=Schema of the table on which the trigger is defined (May be NULL)SYSTEM_TRIGGERCOLUMNS_TABLE_NAME=Table on which the trigger is definedSYSTEM_TRIGGERCOLUMNS_COLUMN_NAME=Name of the column used in the triggerSYSTEM_TRIGGERCOLUMNS_COLUMN_LIST=Column specified in UPDATE clause: e.g. one of ("Y" | "N" }SYSTEM_TRIGGERCOLUMNS_COLUMN_USAGE=How the column is used in the trigger. All applicable combinations of NEW, OLD, IN, OUT, and IN OUT# SYSTEM_TYPEINFOSYSTEM_TYPEINFO_TYPE_NAME=the HSQLDB-specific data type name; this is the canonical name used in CREATE TABLE and ALTER TABLE statements.SYSTEM_TYPEINFO_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_TYPEINFO_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_TYPEINFO_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_TYPEINFO_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_TYPEINFO_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_TYPEINFO_NULLABLE=NULL values allowed for this type?: { No Nulls | Nullable | Unknown }SYSTEM_TYPEINFO_CASE_SENSITIVE=TRUE if the type is case-sensitive in collations and comparisons; FALSE otherwiseSYSTEM_TYPEINFO_SEARCHABLE=use of WHERE?: { None | Char (Only WHERE .. LIKE) | Basic (Except WHERE .. LIKE) | Searchable (All forms of WHERE...) }SYSTEM_TYPEINFO_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_TYPEINFO_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_TYPEINFO_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_TYPEINFO_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_TYPEINFO_MINIMUM_SCALE=minimum scale supportedSYSTEM_TYPEINFO_MAXIMUM_SCALE=maximum scale supportedSYSTEM_TYPEINFO_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_TYPEINFO_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.