How to see all the tables in an HSQLDB database?

by

The ANSI SQL92 standard for querying database metadata is contained within the INFORMATION_SCHEMA data structures.

I have no idea whether your database supports this or not, but try the following:

SELECT *
FROM   INFORMATION_SCHEMA.TABLES

On further research, it appears that HSQLDB does support INFORMATION_SCHEMA, but with slightly non-standard naming.

All of the tables have SYSTEM_* prepended to them, so the above example would read

SELECT *
FROM   INFORMATION_SCHEMA.SYSTEM_TABLES

I have no means of testing this, and the answer was found on sourceforge.

More Related Contents:

  1. Huge performance difference when using GROUP BY vs DISTINCT
  2. How can I insert a new database record in the middle of an existing table?
  3. Convert text to system date format [duplicate]
  4. SQL Access ” Count “? [closed]
  5. What are the options for storing hierarchical data in a relational database?
  6. Splitting string into multiple rows in Oracle
  7. SQL update from one Table to another based on a ID match
  8. SQL JOIN vs IN performance?
  9. Microsoft Jet wildcards: asterisk or percentage sign?
  10. A beginner’s guide to SQL database design [closed]
  11. Check if a row exists, otherwise insert
  12. Pivoting data in MS Access
  13. coalesce alternative in Access SQL
  14. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  15. Combining the results of two SQL queries as separate columns
  16. Postgres Dynamic Query Function
  17. How do I delete a fixed number of rows with sorting in PostgreSQL?
  18. How to check if a string is a uniqueidentifier?
  19. Entity Framework – attribute IN Clause usage
  20. How to see the values of a table variable at debug time in T-SQL?
  21. Deferrable Constraints in SQL Server
  22. Use Access SQL to do a grouped ranking
  23. How do I get textual contents from BLOB in Oracle SQL
  24. SQL Server equivalent to MySQL enum data type?
  25. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  26. Counting the number of occurrences of a substring within a string in PostgreSQL
  27. Designing a SQL schema for a combination of many-to-many relationship (variations of products)
  28. ORA-00942: table or view does not exist (works when a separate sql, but does not work inside a oracle function)
  29. Return rows from INSERT with ON CONFLICT without needing to update
  30. Perform JOIN query in google cloud firestore

Leave a Comment