Board index » delphi » Getting a list of Tables in a Database

Neil McCrossin

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Getting a list of Tables in a Database

Having just connected to a database (Access) at run-time (database file
name not known at design time), can I somehow get a list of all the tables
in the database? The DataSets and DataSetCount properties only refer to
open tables.

Neil McCrossin
Brisbane, Australia

 

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting a list of Tables in a Database


Neil McCrossi

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting a list of Tables in a Database


TSession.GetTableNames

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting a list of Tables in a Database


John Randa

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting a list of Tables in a Database


Quote
In article <01bd3119$b424dca0$1a4901cb@rory> "Neil McCrossin" <n...@gil.com.au> writes:
>From: "Neil McCrossin" <n...@gil.com.au>
>Subject: Getting a list of Tables in a Database
>Date: 4 Feb 1998 03:18:59 GMT
>Having just connected to a database (Access) at run-time (database file
>name not known at design time), can I somehow get a list of all the tables
>in the database? The DataSets and DataSetCount properties only refer to
>open tables.
>Neil McCrossin
>Brisbane, Australia

I don't know about Access, but on a Paradox database the Session component has
a method which gives me a list of tables.

HTH,
         John.

Bill Plunket

Delphi Developer
Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting a list of Tables in a Database


Neil McCrossin <n...@gil.com.au> wrote in article
<01bd3119$b424dca0$1a4901cb@rory>...

Quote
> Having just connected to a database (Access) at run-time (database file
> name not known at design time), can I somehow get a list of all the
tables
> in the database? The DataSets and DataSetCount properties only refer to
> open tables.

> Neil McCrossin
> Brisbane, Australia

Try this:

Session.GetTableNames('My_Database','*.db',False, False,
TableComboBox.Items);

I used this in a program I wrote.  It works fine.  The TableComboBox is a
TComboBox component on a form.  I store the tablenames from the My_Database
alias in the TComboBox's Items.  Use this line after the session is active.

Njoy,
bp

Other Threads

1. Getting a list of Tables in a Database

2. Getting list of View in an SQL-Server database

3. Getting a List of Databases using DBExpress

4. Getting a List of Databases from MySQL/dbexpress

5. Getting a list of the Datasets in an MSACCESS-Database

6. Getting a list of available tables in an Access file

7. Getting List Of Tables In Use

8. Getting List of Tables

9. Question - Getting a table list without password

10. Listing Tables in a Database