Board index » delphi » List of tables in database

List of tables in database

. That's what I'm trying to get.
But not with much luck, so far.
I've tried DbiOpentableList, but for this I need to have a tables open.
Besides, a MSSQL database returns an empty list.

Is there any way to get a list of tables in database/for an alias that works
without opening them? Paradox is easy of course, but the rest..

Any help appreciated
Thanx

-----------------------------------------------------------------------
Jan Doggen / Masters Software
mass...@xs4all.nl
Leiden, The Netherlands
-----------------------------------------------------------------------

 

Re:List of tables in database


Maybe Session.GetTableNames(..) ?

--
Kees Lagendijk
--------------

visit http://www.casema.net/~kens/
for free components

"Messing things up is easy
   but to really create chaos
   you need a computer..."
Jan Doggen heeft geschreven in bericht <7sofvq$bg...@news1.xs4all.nl>...

Quote
>. That's what I'm trying to get.
>But not with much luck, so far.
>I've tried DbiOpentableList, but for this I need to have a tables open.
>Besides, a MSSQL database returns an empty list.

>Is there any way to get a list of tables in database/for an alias that
works
>without opening them? Paradox is easy of course, but the rest..

>Any help appreciated
>Thanx

>-----------------------------------------------------------------------
>Jan Doggen / Masters Software
>mass...@xs4all.nl
>Leiden, The Netherlands
>-----------------------------------------------------------------------

Re:List of tables in database


Have you tried Session.GetTableNames?

Other Threads