Base is NOT a database program. Assuming that you are writing about a HSQLDB of version 1.8 I suggest the following query to be run in direct SQL mode. Dump the results of that query into a report, spreadsheet or whatever type of office document. HSQLDB 1.8 is documented fully at http://hsqldb.org/doc/guide/
####################################### SELECT A.table_type, -- TABLE or VIEW A.hsqldb_type, -- CACHED or TEXT A.table_name, B.column_name, B.type_name, B.column_size FROM information_schema.system_tables as A, information_schema.system_columns as B -- information_schema.system_indexinfo is index information WHERE A.table_schem = 'PUBLIC' AND A.table_name = B.table_name ORDER by A.TABLE_TYPE, A.table_name, B.ordinal_position ############################### This one lists all indices, foreign keys included: -- Index information from all tables in database SELECT A.table_type, A.table_name, B.index_name, B.column_name, B.ordinal_position, B.asc_or_desc, B.non_unique FROM information_schema.system_tables as A, information_schema.system_indexinfo as B WHERE A.table_schem = 'PUBLIC' AND A.table_name = B.table_name ORDER by A.table_type, A.table_name, B.index_name, B.ordinal_position ######################################################## -- View this message in context: http://nabble.documentfoundation.org/Base-List-Tables-Questions-tp3285031p3285089.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
