|
HSQLDB example source code file (TestSelfSysTables.txt)
The HSQLDB TestSelfSysTables.txt source codeSET SCHEMA information_schema; SELECT * FROM SYSTEM_ALIASES; SELECT * FROM SYSTEM_ALLTYPEINFO; SELECT * FROM SYSTEM_BESTROWIDENTIFIER; SELECT * FROM SYSTEM_CACHEINFO; SELECT * FROM SYSTEM_CATALOGS; SELECT * FROM SYSTEM_CHECK_COLUMN_USAGE; SELECT * FROM SYSTEM_CHECK_CONSTRAINTS; SELECT * FROM SYSTEM_CHECK_ROUTINE_USAGE; SELECT * FROM SYSTEM_CHECK_TABLE_USAGE; SELECT * FROM SYSTEM_CLASSPRIVILEGES; SELECT * FROM SYSTEM_COLUMNPRIVILEGES; SELECT * FROM SYSTEM_COLUMNS; SELECT * FROM SYSTEM_CROSSREFERENCE; SELECT * FROM SYSTEM_INDEXINFO; SELECT * FROM SYSTEM_PRIMARYKEYS; SELECT * FROM SYSTEM_PROCEDURECOLUMNS; SELECT * FROM SYSTEM_PROCEDURES; SELECT * FROM SYSTEM_PROPERTIES; SELECT * FROM SYSTEM_SCHEMAS; SELECT * FROM SYSTEM_SEQUENCES; SELECT * FROM SYSTEM_SESSIONINFO; SELECT * FROM SYSTEM_SESSIONS; SELECT * FROM SYSTEM_SUPERTABLES; SELECT * FROM SYSTEM_SUPERTYPES; SELECT * FROM SYSTEM_TABLEPRIVILEGES; SELECT * FROM SYSTEM_TABLES; SELECT * FROM SYSTEM_TABLETYPES; SELECT * FROM SYSTEM_TABLE_CONSTRAINTS; SELECT * FROM SYSTEM_TEXTTABLES; SELECT * FROM SYSTEM_TRIGGERCOLUMNS; SELECT * FROM SYSTEM_TRIGGERS; SELECT * FROM SYSTEM_TYPEINFO; SELECT * FROM SYSTEM_UDTATTRIBUTES; SELECT * FROM SYSTEM_UDTS; SELECT * FROM SYSTEM_USAGE_PRIVILEGES; SELECT * FROM SYSTEM_USERS; SELECT * FROM SYSTEM_VERSIONCOLUMNS; SELECT * FROM SYSTEM_VIEWS; SELECT * FROM SYSTEM_VIEW_COLUMN_USAGE; SELECT * FROM SYSTEM_VIEW_ROUTINE_USAGE; SELECT * FROM SYSTEM_VIEW_TABLE_USAGE; Other HSQLDB examples (source code examples)Here is a short list of links related to this HSQLDB TestSelfSysTables.txt source code file: |
... this post is sponsored by my books ... | |
#1 New Release! |
FP Best Seller |
Copyright 1998-2021 Alvin Alexander, alvinalexander.com
All Rights Reserved.
A percentage of advertising revenue from
pages under the /java/jwarehouse
URI on this website is
paid back to open source projects.