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.
"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)
srinivas
try this query from the progress editor
select _desc from _file where _file-name = Srinivas K.