[libreoffice-users] Re: Base List Tables Questions

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+help@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