Print list of fields in table

Yahoo Archive
1
If you are using SQL...

use mfgsys803
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME =
'tablename'

then just change the 'tablename' to the name of the table you are looking
for.

there is probably something similar in OpenEdge via there tools but I am
unaware of what they are.


----- Original Message -----
From: "Charlie Wilson" <foamdesigncsw@...>
To: <vantage@yahoogroups.com>
Sent: Monday, April 06, 2009 12:12 PM
Subject: [Vantage] Print list of fields in table


>I need to be able to print off a list of all the fields in a table any one
> know of a way to do this?
>
>
>
> ~Charlie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
2
I need to be able to print off a list of all the fields in a table any one
know of a way to do this?



~Charlie





[Non-text portions of this message have been removed]
3
System Management -- Data Dictionary Viewer -- Search for a table -- Actions -- Print Field Definitions -- Filter -- Search for the table again -- Print.

Hint: It's very convenient to filter for multiple tables when viewing them. But, don't filter for more than one table at a time for printing. If you print multiple tables with the same Print command, it will put the second table directly beneath the first one on the same page. This is very inconvenient. It's better to ask for only 1 hardcopy at a time so that you can staple all the pages for each table together and each table will be separate.



--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...> wrote:
>
> I need to be able to print off a list of all the fields in a table any one
> know of a way to do this?
>
>
>
> ~Charlie
>
>
>
>
>
> [Non-text portions of this message have been removed]
>