ge.schemacrawler.schemacrawler-hsqldb.10.08.02.source-code.schemacrawler-hsqldb.config.properties Maven / Gradle / Ivy
driver=org.hsqldb.jdbc.JDBCDriver
host=localhost
port=9001
url=jdbc:hsqldb:hsql://${host}:${port}/${database};readonly=true;hsqldb.lock_file=false
select.INFORMATION_SCHEMA.ROUTINES=\
SELECT \
* \
FROM \
INFORMATION_SCHEMA.ROUTINES \
ORDER BY \
ROUTINE_CATALOG, \
ROUTINE_SCHEMA, \
ROUTINE_NAME
select.INFORMATION_SCHEMA.VIEWS=\
SELECT \
* \
FROM \
INFORMATION_SCHEMA.VIEWS \
ORDER BY \
TABLE_CATALOG, \
TABLE_SCHEMA, \
TABLE_NAME
select.INFORMATION_SCHEMA.TRIGGERS=\
SELECT \
* \
FROM \
INFORMATION_SCHEMA.TRIGGERS \
ORDER BY \
TRIGGER_CATALOG, \
TRIGGER_SCHEMA, \
TRIGGER_NAME
select.INFORMATION_SCHEMA.TABLE_CONSTRAINTS=\
SELECT \
* \
FROM \
INFORMATION_SCHEMA.TABLE_CONSTRAINTS \
ORDER BY \
CONSTRAINT_CATALOG, \
CONSTRAINT_SCHEMA, \
CONSTRAINT_NAME
select.INFORMATION_SCHEMA.EXT_TABLE_CONSTRAINTS=\
SELECT \
* \
FROM \
INFORMATION_SCHEMA.CHECK_CONSTRAINTS \
ORDER BY \
CONSTRAINT_CATALOG, \
CONSTRAINT_SCHEMA, \
CONSTRAINT_NAME
select.ADDITIONAL_COLUMN_ATTRIBUTES=\
SELECT \
TABLE_CATALOG, \
TABLE_SCHEMA, \
TABLE_NAME, \
COLUMN_NAME, \
IS_GENERATED, \
GENERATION_EXPRESSION \
FROM \
INFORMATION_SCHEMA.COLUMNS
select.ADDITIONAL_TABLE_ATTRIBUTES=\
SELECT \
TABLE_CATALOG, \
TABLE_SCHEMA, \
TABLE_NAME, \
COMMIT_ACTION \
FROM \
INFORMATION_SCHEMA.TABLES