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
Kelloggs