Andreas, Wow! Where to start. First, Base (part of LibreOffice 3.3) is described as a database program, and that is what I want.
As for the db engine, I have no clue, and could care less. As for the query -- why??? I'm trying to follow along with the Getting Started with Base guide, but it has left out a step or two. So I need someone to fill in the missing information based on what I have, not what you have. Don't mean to be fussy, but I don't see how this helps me in any way, and I don't fully understand it. So I would appreciate it if someone could explain how I make the links so I can creat a form and some reports. Thanks again, Dave On Thu, 25 Aug 2011 14:14 -0700, "Andreas Säger" <ville...@t-online.de> wrote: > 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 > > -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Accessible with your email software or over the web -- 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
