Getting tables names from Servers

Kevin Willems

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Getting tables names from Servers

Does anyone know a generic way to get a list of tablenames from a
Database, regardless of what kind of back-end? This should work on
anything from Paradox to Oracle.

Thanks in advance,

Kevin Willems

Scott Frolich [Borland

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting tables names from Servers

Quote

Kevin Willems wrote:

> Does anyone know a generic way to get a list of tablenames from a
> Database, regardless of what kind of back-end? This should work on
> anything from Paradox to Oracle.

> Thanks in advance,

> Kevin Willems

Hello,
Use session.gettablenames (Delphi) or DbiOpenTableList (BDE API)

Scott
--
BDE Support:
http://www.borland.com/devsupport/bde
Delphi Support:
http://www.borland.com/devsupport/delphi
Common Delphi and BDE Questions and Answers:
http://www.borland.com/devsupport/delphi/qanda/delphi3qa.html

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting tables names from Servers

Session.GetTableNames('DB', '',False, False, MyStringList);
where DB is the database name of your tdatabase component.

Quote

Kevin Willems wrote:
> Does anyone know a generic way to get a list of tablenames from a
> Database, regardless of what kind of back-end? This should work on
> anything from Paradox to Oracle.

> Thanks in advance,

> Kevin Willems

Kevin Willem

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Getting tables names from Servers

Quote

> Session.GetTableNames('DB', '',False, False, MyStringList);
> where DB is the database name of your tdatabase component.

Thanks. I knew it was probably something simple.

Kevin

Other Threads

1. Getting table names without prompt from user name and password

2. Getting Table names and Field names.

3. getting smtp mail server name

4. Getting Server Name from DataLink

5. Getting SQL server database name from TDatabase /BDE

6. MSSQL - getting NT server name from ODBC alias

7. Getting Server Name from TDatabase.Params

8. Getting the Server Name

9. Getting Table Name for Query

10. Getting table names from Access DB