Hi Bert,
 
Thank You for your mail.
 
I got the info. required for Firebird, but if it is ppossible for you to provide any link or info for Paradox database, so pl let me know.
 
 
If anybody could provide me the req. link or info for Paradox database, it would be highly appreciated.
 
 
Thank You once again.
 
With Best Regards.
 

--- On Sun, 3/10/10, Bert_Herngreen <bert_herngreen@...> wrote:


From: Bert_Herngreen <bert_herngreen@...>
Subject: [firebird-support] Re: How To Get List of Tables and Table Structure of Each Table
To: firebird-support@yahoogroups.com
Date: Sunday, 3 October, 2010, 4:27 PM


 



Hi,

select rdb$relation_name from rdb$relations
where rdb$system_flag=0

lists all user defined tables.

If you want more (field) details, you could take a look at
Lorenzo Alberton's page which contains a lot of examples:

http://www.alberton.info/firebird_sql_meta_info.html

Kind regards,
Bert










[Non-text portions of this message have been removed]