Getting all tablenames from af DB

[N/A]

Hi.

Does anyone know how to get all the tablenames from a DB?

I'm looking for a procedure like

Table1.GetFieldNames(ListBox1.Items);

- which put all the fieldnames from Table1 into ListBox1.

Mads

[N/A]

This would differ depending upon the DBMS you are
using.

For instance, in SQLServer, you have to query the
system tables for all the tablenames.

You didn't say what DBMS you were using so we can't give you a reliable answer...

[N/A]

Sorry.

I'm using MS Access '97.

Hope You can help.

Mads

[N/A]

Try the mODBC component, it has a function like you want:

DataBase.GetTableName( ListBox1.Items );