Inside a database, sql query to get a list of tables

[GerardSAUVAGE]

Hello everybody,

Inside a database, does somebody know how to get a list of tables & a list of a table’s fields using SQL an SQL only ?

(LibreOffice Base on Windows Vista and/or 8.)

Thank you for your help.

Gerard SAUVAGE

[黄智壯]

A NON-SQL method would be through JDBC:
Jenkov.com example,
Oracle.com reference.
Which you might want to try in case there are no SQL-ONLY methods.

[w_whalley]

If you are using the embedded HSQLDB engine these will give you that information.
Table names are in column TABLE_NAME in this query:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES WHERE TABLE_TYPE='TABLE';

Column names (and other column parameters) are obtained by this query:

SELECT * FROM INFORMATION_SCHEMA.SYSTEM_COLUMNS WHERE TABLE_NAME NOT LIKE 'SYSTEM_%';

[GerardSAUVAGE]

Hello,

Both of the commands work well. Thank you very much for your help.

[mariosv]

Hi Gerard, seems the @w_whalley answer is fine, please tick the answer as correct.