ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> Current list of tables
http://www.istechforum.com/YaBB.pl?num=1364473425

Message started by David Waldmann on 03/28/13 at 05:23:45

Title: Current list of tables
Post by David Waldmann on 03/28/13 at 05:23:45

Is there one already available somewhere? If not, is there a way to generate one with the Pervasive utilities?

Of course, it would ideally have a description as well as all the fields and their purpose as well, like an updated and expanded "DBAFILE" that I got a decade or so ago...

??

Title: Re: Current list of tables
Post by Lynn_Pantic on 03/28/13 at 16:35:56

I suspect there is a way to generate one using the JDBC connection because the DE-A Query Wizard had to generate the list to know what to present in the wizard. Let me check into it.

Title: Re: Current list of tables
Post by David Waldmann on 03/29/13 at 04:44:44

Got it.
Thanks!
-d

Title: Re: Current list of tables
Post by Prier Products on 03/21/14 at 09:31:36

I would love to have this too!

Title: Re: Current list of tables
Post by Kelloggs on 03/21/14 at 11:07:21

On your pervasive control center or ms access if you have it (pass-through query)

This selects all table names and their corresponding data file names:
Select * from X$File

This selects all the fields for a table named 'WORKORD':

Select Xf$Name, X$Field.* from X$File, X$Field
WHERE Xf$Id = Xe$File and Xf$Name = 'WORKORD' and Xe$DataType < 200
ORDER BY Xe$offset

:P

Kelloggs

Title: Re: Current list of tables
Post by Lynn_Pantic on 03/21/14 at 14:33:47

There is also a relatively new Excel file listing the fields and tables on the Resources page of the ISTECHSUPPORT.COM website. Better than the 10 year old one David was referring to.

Title: Re: Current list of tables
Post by Prier Products on 03/21/14 at 14:37:56

Thank you Lynn. Just what I was looking for.