column-remarks.properties

hsqldb是100％java实现的数据库,是一个开放源代码的JAVA数据库 l 具有标准的SQL语法和JAVA接口 l HSQLDB可以自由使用和分发 l 非常简洁和快速的

# SYSTEM_LOBS
SYSTEM_LOBS_NAME=Java classfile encoded absolute name of a resource ( /dir1/.../dirn/resourcename.ext)
SYSTEM_LOBS_CONTENT=binary content of Java class file or resource
SYSTEM_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 loaded
SYSTEM_LOBS_MODIFIED=time at which content was last modified
# SYSTEM_PRIMARYKEYS
SYSTEM_PRIMARYKEYS_TABLE_CAT=catalog in which table containing primary key is defined
SYSTEM_PRIMARYKEYS_TABLE_SCHEM=schema in which table containing primary key is defined
SYSTEM_PRIMARYKEYS_TABLE_NAME=simple name of table containing primary key
SYSTEM_PRIMARYKEYS_COLUMN_NAME=simple name of column participating in primary key
SYSTEM_PRIMARYKEYS_KEY_SEQ=sequence number of column within primary key
SYSTEM_PRIMARYKEYS_PK_NAME=primary key name
# SYSTEM_PROCEDURECOLUMNS
SYSTEM_PROCEDURECOLUMNS_PROCEDURE_CAT=catalog in which procedure is defined
SYSTEM_PROCEDURECOLUMNS_PROCEDURE_SCHEM=schema in which procedure is defined
SYSTEM_PROCEDURECOLUMNS_PROCEDURE_NAME=procedure identifier
SYSTEM_PROCEDURECOLUMNS_COLUMN_NAME=( result column | call parameter | return value ) name
SYSTEM_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 applicable
SYSTEM_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 types
SYSTEM_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 column
SYSTEM_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 point
SYSTEM_PROCEDURECOLUMNS_SEQ=provides the ability to deliver rows in JDBC DataseMetaData sort contrct order
# SYSTEM_PROCEDURES
SYSTEM_PROCEDURES_PROCEDURE_CAT=catalog in which procedure is defined
SYSTEM_PROCEDURES_PROCEDURE_SCHEM=schema in which procedure is defined
SYSTEM_PROCEDURES_PROCEDURE_NAME=procedure identifier
SYSTEM_PROCEDURES_REMARKS=explanatory comment on the procedure
SYSTEM_PROCEDURES_PROCEDURE_TYPE=kind of procedure: { Unknown | No Result | Returns Result }
SYSTEM_PROCEDURES_NUM_INPUT_PARAMS=number of procedure input parameters
SYSTEM_PROCEDURES_NUM_OUTPUT_PARAMS=number of procedure output parameters
SYSTEM_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_PROPERTIES
SYSTEM_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 property
SYSTEM_PROPERTIES_PROPERTY_VALUE=the current value of the property
SYSTEM_PROPERTIES_PROPERTY_CLASS=the type of the value, e.g. ( int | boolean | java.lang.String | ...)
# SYSTEM_SCHEMAS
SYSTEM_SCHEMAS_TABLE_SCHEM=schema name
SYSTEM_SCHEMAS_TABLE_CATALOG=catalog in which schema is defined
SYSTEM_SCHEMAS_IS_DEFAULT=whether the described schema is the default schema
# SYSTEM_SESSIONS
SYSTEM_SESSIONS_SESSION_ID=session identifier
SYSTEM_SESSIONS_CONNECTED=time at which session connected to database
SYSTEM_SESSIONS_USER_NAME=name of session user, as known to the database
SYSTEM_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.0
SYSTEM_SESSIONS_SCHEMA=this session's current default schema
# SYSTEM_SESSIONINFO
SYSTEM_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_SUPERTABLES
SYSTEM_SUPERTABLES_TABLE_CAT=the table's catalog
SYSTEM_SUPERTABLES_TABLE_SCHEM=table schema
SYSTEM_SUPERTABLES_TABLE_NAME=table name
SYSTEM_SUPERTABLES_SUPERTABLE_NAME=the direct super table's name
# SYSTEM_SUPERTYPES
SYSTEM_SUPERTYPES_TYPE_CAT=the UDT's catalog
SYSTEM_SUPERTYPES_TYPE_SCHEM=UDT's schema
SYSTEM_SUPERTYPES_TYPE_NAME=type name of the UDT
SYSTEM_SUPERTYPES_SUPERTYPE_CAT=the direct super type's catalog
SYSTEM_SUPERTYPES_SUPERTYPE_SCHEM=the direct super type's schema
SYSTEM_SUPERTYPES_SUPERTYPE_NAME=the direct super type's name
# SYSTEM_TABLEPRIVILEGES
SYSTEM_TABLEPRIVILEGES_TABLE_CAT=table catalog
SYSTEM_TABLEPRIVILEGES_TABLE_SCHEM=table schema
SYSTEM_TABLEPRIVILEGES_TABLE_NAME=table name
SYSTEM_TABLEPRIVILEGES_GRANTOR=grantor of access
SYSTEM_TABLEPRIVILEGES_GRANTEE=grantee of access
SYSTEM_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_TABLES
SYSTEM_TABLES_TABLE_CAT=table catalog
SYSTEM_TABLES_TABLE_SCHEM=table schema
SYSTEM_TABLES_TABLE_NAME=table name
SYSTEM_TABLES_TABLE_TYPE=table type: e.g. one of { TABLE | VIEW | SYSTEM TABLE | GLOBAL TEMPORARY ... }
SYSTEM_TABLES_REMARKS=explanatory comment on the table
SYSTEM_TABLES_TYPE_CAT=table type catalog
SYSTEM_TABLES_TYPE_SCHEM=table type schema
SYSTEM_TABLES_TYPE_NAME=table type name
SYSTEM_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_TABLETYPES
SYSTEM_TABLETYPES_TABLE_TYPE=table type name
# SYSTEM_TEXTTABLES
SYSTEM_TEXTTABLES_TABLE_CAT=table catalog
SYSTEM_TEXTTABLES_TABLE_SCHEM=table schema
SYSTEM_TEXTTABLES_TABLE_NAME=table name
SYSTEM_TEXTTABLES_DATA_SOURCE_DEFINTION=the "spec" proption of the table's SET TABLE ... SOURCE DDL declaration
SYSTEM_TEXTTABLES_FILE_PATH=path to table's text file data source
SYSTEM_TEXTTABLES_FILE_ENCODING=encoding of table's text file data source
SYSTEM_TEXTTABLES_FIELD_SEPARATOR=the default field separator
SYSTEM_TEXTTABLES_VARCHAR_SEPARATOR=varchar field separator
SYSTEM_TEXTTABLES_LONGVARCHAR_SEPARATOR=longvarchar field separator
SYSTEM_TEXTTABLES_IS_IGNORE_FIRST=ignores first line of file?
# added to reflect 1.7.2 RC1
SYSTEM_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_TRIGGERS
SYSTEM_TRIGGERS_TRIGGER_CAT=Trigger catalog
SYSTEM_TRIGGERS_TRIGGER_SCHEM=Trigger Schema
SYSTEM_TRIGGERS_TRIGGER_NAME=Trigger Name
SYSTEM_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 defined
SYSTEM_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, NULL
SYSTEM_TRIGGERS_BASE_OBJECT_TYPE=The base object on which the trigger is defined: TABLE, VIEW, SCHEMA, or DATABASE
SYSTEM_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 defined
SYSTEM_TRIGGERS_COLUMN_NAME=Name of the nested table column (if nested table trigger), else NULL
SYSTEM_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 DDL
SYSTEM_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_TRIGGERCOLUMNS
SYSTEM_TRIGGERCOLUMNS_TRIGGER_CAT=Trigger catalog
SYSTEM_TRIGGERCOLUMNS_TRIGGER_SCHEM=Trigger schema
SYSTEM_TRIGGERCOLUMNS_TRIGGER_NAME=Trigger name
SYSTEM_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 defined
SYSTEM_TRIGGERCOLUMNS_COLUMN_NAME=Name of the column used in the trigger
SYSTEM_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_TYPEINFO
SYSTEM_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 applicable
SYSTEM_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 applicable
SYSTEM_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 otherwise
SYSTEM_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 boxes
SYSTEM_TYPEINFO_MINIMUM_SCALE=minimum scale supported
SYSTEM_TYPEINFO_MAXIMUM_SCALE=maximum scale supported
SYSTEM_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.