Table Description in Progress

Posted by LegacyUser on 12-Mar-2001 00:33

Hi

I need a query which will get me the description of a specified table. (something like Desc table_name in Oracle).

I would be greatful if anyone can help me out in this.

Thanks in advance,

Srinivas K.

All Replies

Posted by LegacyUser on 12-Mar-2001 11:10

"Srinivas" wrote:

>

>Hi

>

>I need a query which will get me the description of a

>specified table. (something like Desc table_name in Oracle).

>

>I would be greatful if anyone can help me out in this.

>

>Thanks in advance,

>Srinivas K.

Maybe something like this (if I understand your question):

FOR EACH _file

WHERE file.file-name EQ ""

NO-LOCK:

DISPLAY

_file.

END.

You may want additional Data Dictionary info so...

FOR EACH _file

WHERE file.file-name EQ ""

NO-LOCK,

EACH _field

OF _file

NO-LOCK,

EACH _index

OF _file

WHERE index.active

NO-LOCK,

EACH _index-field

OF _index

NO-LOCK:

DISPLAY

file.file-name

field.field-name

etc...

If this is something like you're asking for, I can email you a sample program...

Kevin (book@flash.net)

Posted by LegacyUser on 15-Mar-2001 12:00

srinivas

try this query from the progress editor

select _desc from _file where _file-name = Srinivas K.

This thread is closed