System Information

generated by SchemaCrawler 16.1.2
generated on 2019-10-09 01:01:25
database version HSQL Database Engine 2.5.0
driver version HSQL Database Engine Driver 2.5.0

 

 

Routines

NEW_PUBLISHER [procedure, no result]
PUBLISHER CHARACTER VARYING, out
[specific name]
NEW_PUBLISHER_FORCE_VALUE
Definition
[definition]
CREATE PROCEDURE BOOKS.NEW_PUBLISHER(OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_FORCE_VALUE LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = 'New Publisher'

 

NEW_PUBLISHER [procedure, no result]
NEWPUBLISHER CHARACTER VARYING, in
PUBLISHER CHARACTER VARYING, out
[specific name]
NEW_PUBLISHER_10160
Definition
[definition]
CREATE PROCEDURE BOOKS.NEW_PUBLISHER(IN NEWPUBLISHER VARCHAR(50),OUT PUBLISHER VARCHAR(50)) SPECIFIC NEW_PUBLISHER_10160 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL NEW SAVEPOINT LEVEL SET PUBLISHER = NEWPUBLISHER

 

CUSTOMADD [function, does not return a table]
ONE INTEGER, in
[specific name]
CUSTOMADD_10162
Definition
[definition]
CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10162 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN BOOKS.CUSTOMADD(ONE,1)

 

CUSTOMADD [function, does not return a table]
ONE INTEGER, in
TWO INTEGER, in
[specific name]
CUSTOMADD_10161
Definition
[definition]
CREATE FUNCTION BOOKS.CUSTOMADD(IN ONE INTEGER,IN TWO INTEGER) RETURNS INTEGER SPECIFIC CUSTOMADD_10161 LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL CALLED ON NULL INPUT RETURN ONE+TWO

 

 

Data Types

BIGINT [data type]
defined with no parameters
nullable
auto-incrementable
searchable except with where .. like

 

BINARY [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable

 

BIT [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable except with where .. like

 

BLOB [data type]
defined with LENGTH
nullable
not auto-incrementable
not searchable

 

BOOLEAN [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

CHARACTER [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable

 

CLOB [data type]
defined with LENGTH
nullable
not auto-incrementable
not searchable

 

DATE [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

DECIMAL [data type]
defined with PRECISION,SCALE
nullable
auto-incrementable
searchable except with where .. like

 

DOUBLE [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

FLOAT [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

INTEGER [data type]
defined with no parameters
nullable
auto-incrementable
searchable except with where .. like

 

NUMERIC [data type]
defined with PRECISION,SCALE
nullable
auto-incrementable
searchable except with where .. like

 

NVARCHAR [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable

 

OTHER [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

REAL [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

SMALLINT [data type]
defined with no parameters
nullable
auto-incrementable
searchable except with where .. like

 

TIME [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

TIMESTAMP [data type]
defined with no parameters
nullable
not auto-incrementable
searchable except with where .. like

 

TINYINT [data type]
defined with no parameters
nullable
auto-incrementable
searchable except with where .. like

 

UUID [data type]
defined with no parameters
nullable
not auto-incrementable
searchable

 

VARBINARY [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable

 

VARCHAR [data type]
defined with LENGTH
nullable
not auto-incrementable
searchable

 

AGE_TYPE [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on SMALLINT

 

CHARACTER VARYING [data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable

 

NAME_TYPE [user defined data type]
defined with no parameters
not nullable
not auto-incrementable
not searchable
based on NVARCHAR

 

 

System Information

SchemaCrawler Information

product name SchemaCrawler
product version 16.1.2

 

Database Information

database product name HSQL Database Engine
database product version 2.5.0
database user name SA

 

Database Characteristics

all procedures are callable true
all tables are selectable true
auto commit failure closes all result sets false
catalog separator .
catalog term CATALOG
catalogs PUBLIC
client info properties files_readonly, hsqldb.applog, hsqldb.cache_file_scale, hsqldb.cache_free_count, hsqldb.cache_rows, hsqldb.cache_size, hsqldb.default_table_type, hsqldb.defrag_limit, hsqldb.digest, hsqldb.files_space, hsqldb.full_log_replay, hsqldb.inc_backup, hsqldb.large_data, hsqldb.lob_compressed, hsqldb.lob_file_scale, hsqldb.lock_file, hsqldb.log_data, hsqldb.log_size, hsqldb.min_reuse, hsqldb.nio_data_file, hsqldb.nio_max_size, hsqldb.result_max_memory_rows, hsqldb.script_format, hsqldb.sqllog, hsqldb.temp_directory, hsqldb.tx, hsqldb.tx_conflict_rollback, hsqldb.tx_interrupt_rollback, hsqldb.tx_level, hsqldb.write_delay, hsqldb.write_delay_millis, jdbc.translate_tti_types, readonly, runtime.gc_interval, sql.avg_scale, sql.char_literal, sql.compare_in_locale, sql.concat_nulls, sql.convert_trunc, sql.double_nan, sql.enforce_names, sql.enforce_refs, sql.enforce_size, sql.enforce_tdc_delete, sql.enforce_tdc_update, sql.enforce_types, sql.ignore_case, sql.live_object, sql.longvar_is_lob, sql.nulls_first, sql.nulls_order, sql.pad_space, sql.ref_integrity, sql.regular_names, sql.restrict_exec, sql.syntax_db2, sql.syntax_mss, sql.syntax_mys, sql.syntax_ora, sql.syntax_pgs, sql.sys_index_names, sql.unique_nulls, textdb.all_quoted, textdb.cache_rows, textdb.cache_scale, textdb.cache_size, textdb.cache_size_scale, textdb.encoding, textdb.fs, textdb.ignore_first, textdb.lvs, textdb.qc, textdb.quoted, textdb.vs
data definition causes transaction commit true
data definition ignored in transactions false
database major version 2
database minor version 5
default transaction isolation 2
deletes are detected for TYPE_FORWARD_ONLY result sets false
deletes are detected for TYPE_SCROLL_INSENSITIVE result sets false
deletes are detected for TYPE_SCROLL_SENSITIVE result sets false
does max row size include blobs true
driver major version 2
driver minor version 5
extra name characters
generated key always returned true
identifier quote string "
inserts are detected for TYPE_FORWARD_ONLY result sets false
inserts are detected for TYPE_SCROLL_INSENSITIVE result sets false
inserts are detected for TYPE_SCROLL_SENSITIVE result sets false
is catalog at start true
is read only false
JDBC major version 4
JDBC minor version 2
locators update copy false
max binary literal length 0
max catalog name length 128
max char literal length 0
max column name length 128
max columns in group by 0
max columns in index 0
max columns in order by 0
max columns in select 0
max columns in table 0
max connections 0
max cursor name length 128
max index length 0
max logical lob size 1099511627776
max procedure name length 128
max row size 0
max schema name length 128
max statement length 0
max statements 0
max table name length 128
max tables in select 0
max user name length 128
null plus non null is null true
nulls are sorted at end false
nulls are sorted at start true
nulls are sorted high false
nulls are sorted low false
numeric functions ABS, ACOS, ASIN, ATAN, ATAN2, BITAND, BITOR, BITXOR, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, RADIANS, RAND, ROUND, ROUNDMAGIC, SIGN, SIN, SQRT, TAN, TRUNCATE
others deletes are visible for TYPE_FORWARD_ONLY result sets false
others deletes are visible for TYPE_SCROLL_INSENSITIVE result sets false
others deletes are visible for TYPE_SCROLL_SENSITIVE result sets false
others inserts are visible for TYPE_FORWARD_ONLY result sets false
others inserts are visible for TYPE_SCROLL_INSENSITIVE result sets false
others inserts are visible for TYPE_SCROLL_SENSITIVE result sets false
others updates are visible for TYPE_FORWARD_ONLY result sets false
others updates are visible for TYPE_SCROLL_INSENSITIVE result sets false
others updates are visible for TYPE_SCROLL_SENSITIVE result sets false
own deletes are visible for TYPE_FORWARD_ONLY result sets false
own deletes are visible for TYPE_SCROLL_INSENSITIVE result sets false
own deletes are visible for TYPE_SCROLL_SENSITIVE result sets false
own inserts are visible for TYPE_FORWARD_ONLY result sets false
own inserts are visible for TYPE_SCROLL_INSENSITIVE result sets false
own inserts are visible for TYPE_SCROLL_SENSITIVE result sets false
own updates are visible for TYPE_FORWARD_ONLY result sets false
own updates are visible for TYPE_SCROLL_INSENSITIVE result sets false
own updates are visible for TYPE_SCROLL_SENSITIVE result sets false
procedure term PROCEDURE
result set holdability 1
row id lifetime ROWID_UNSUPPORTED
schema term SCHEMA
schemas BOOKS, FOR_LINT, INFORMATION_SCHEMA, PUBLIC, PUBLISHER SALES, SYSTEM_LOBS
search string escape \
SQL keywords
SQL state type 2
stores lower case identifiers false
stores lower case quoted identifiers false
stores mixed case identifiers false
stores mixed case quoted identifiers false
stores upper case identifiers true
stores upper case quoted identifiers false
string functions ASCII, CHAR, CONCAT, DIFFERENCE, HEXTORAW, INSERT, LCASE, LEFT, LENGTH, LOCATE, LTRIM, RAWTOHEX, REPEAT, REPLACE, RIGHT, RTRIM, SOUNDEX, SPACE, SUBSTR, UCASE
supports alter table with add column true
supports alter table with drop column true
supports ANSI92 entry level SQL true
supports ANSI92 full SQL true
supports ANSI92 intermediate SQL true
supports batch updates true
supports catalogs in data manipulation true
supports catalogs in index definitions true
supports catalogs in privilege definitions true
supports catalogs in procedure calls true
supports catalogs in table definitions true
supports column aliasing true
supports convert true
supports core SQL grammar true
supports correlated subqueries true
supports data definition and data manipulation transactions false
supports data manipulation transactions only true
supports different table correlation names false
supports expressions in order by true
supports extended SQL grammar true
supports full outer joins true
supports get generated keys true
supports group by true
supports group by beyond select true
supports group by unrelated true
supports integrity enhancement facility true
supports like escape clause true
supports limited outer joins true
supports minimum SQL grammar true
supports mixed case identifiers false
supports mixed case quoted identifiers true
supports multiple open results true
supports multiple result sets true
supports multiple transactions true
supports named parameters true
supports non nullable columns true
supports open cursors across commit true
supports open cursors across rollback false
supports open statements across commit true
supports open statements across rollback true
supports order by unrelated true
supports outer joins true
supports positioned delete true
supports positioned update true
supports ref cursors false
supports result set type for TYPE_FORWARD_ONLY result sets true
supports result set type for TYPE_SCROLL_INSENSITIVE result sets true
supports result set type for TYPE_SCROLL_SENSITIVE result sets false
supports savepoints true
supports schemas in data manipulation true
supports schemas in index definitions true
supports schemas in privilege definitions true
supports schemas in procedure calls true
supports schemas in table definitions true
supports select for update true
supports statement pooling true
supports stored functions using call syntax true
supports stored procedures true
supports subqueries in comparisons true
supports subqueries in exists true
supports subqueries in ins true
supports subqueries in quantifieds true
supports table correlation names true
supports transactions true
supports union true
supports union all true
system functions DATABASE, IFNULL, USER
table types GLOBAL TEMPORARY, SYSTEM TABLE, TABLE, VIEW
time date functions CURDATE, CURTIME, DATEDIFF, DAYNAME, DAYOFMONTH, DAYOFWEEK, DAYOFYEAR, HOUR, MINUTE, MONTH, MONTHNAME, NOW, QUARTER, SECOND, SECONDS_SINCE_MIDNIGHT, TIMESTAMPADD, TIMESTAMPDIFF, TO_CHAR, WEEK, YEAR
type info BIT, TINYINT, BIGINT, VARBINARY, BINARY, UUID, CHARACTER, NUMERIC, DECIMAL, INTEGER, SMALLINT, DOUBLE, FLOAT, REAL, NVARCHAR, VARCHAR, BOOLEAN, DATE, TIME, TIMESTAMP, OTHER, BLOB, CLOB
updates are detected for TYPE_FORWARD_ONLY result sets false
updates are detected for TYPE_SCROLL_INSENSITIVE result sets false
updates are detected for TYPE_SCROLL_SENSITIVE result sets false
uses local file per table false
uses local files false

 

JDBC Driver Information

driver name HSQL Database Engine Driver
driver version 2.5.0
driver class name org.hsqldb.jdbc.JDBCDriver
url jdbc:hsqldb:hsql://0.0.0.0:56161/schemacrawler56161
is JDBC compliant true

 

JDBC Driver Properties

default_schema [driver property]
not required; choices [false, true]
value false

 

get_column_name [driver property]
not required; choices [false, true]
value true

 

ifexists [driver property]
not required; choices [false, true]
value false

 

password [driver property]
required
value NULL

 

shutdown [driver property]
not required; choices [false, true]
value false

 

user [driver property]
required
value NULL