I've searched theforums and on-line technical library but have been unable to find a answer to the following "HOW TO"

Is it possible to print a Database Schema that prints out a list of tables with field definitions/description?

Jeff, it probably is difficult to design a tool that prints the schema of all the different types of databases that WebFOCUS can access, I suggest you use the supplied tools of the particular database you're working with.

I might not have stated my requirement correctly and made is seem more complex than it really is. Basically what I would like to accomplish is just to be able to print out a list of fields in a particular table i.e. Field name, Type, size

Thanks

?FF master-file-name

e.g.: ?FF CAR

THANK YOU FRANCIS!
Just what I was looking for.
Jeff

CHECK FILE CAR HOLD
TABLE FILE HOLD
PRINT FIELDNAME
BY SEGNAME
END

This is a useful tool. You can find more description here:

http://documentation.informationbuilders.com/masterinde...g/source/topic89.htm

Hope this helps.

I should mention where this is documented:

Creating Reports With WebFOCUS Language > Referring to Fields in a Report Request > Displaying a List of Field Names > Listing Field Names, Aliases, and Format Information

Jeff

Tony S posted this little piece of coding to help me with a similar problem

-SET &ECHO = ON;
TABLE FILE SYSCOLUM
PRINT NAME
      USAGE
   BY SEGNAME NOPRINT
   BY SEGNO   NOPRINT
WHERE TBNAME EQ '&TABLENAME'
ON TABLE SAVE
ON TABLE SET HOLDLIST PRINTONLY
END
-RUN
TABLE FILE &TABLENAME
PRINT
-READ SAVE &FieldName.A66. &Format.A8.
-REPEAT :Loop WHILE &IORETURN EQ 0;
&FieldName AS '&FieldName - &Format'
-READ SAVE &FieldName.A66. &Format.A8.
-:Loop
HEADING
"&TABLENAME"
IF RECORDLIMIT EQ 10
END

What this does is displaying the fields of a database with the format in the header and the first 10 records from that database for a "&TABLENAME".

If you put the tablenames for a certain database in a small list, you can do this with an extra loop for all the tables all at once, and combine it with the other answers to build your documentation.

Thanks Frank.
Appreciate the help.

Jeff