Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Describing a Table

0 views
Skip to first unread message

James

unread,
May 16, 2002, 11:14:23 PM5/16/02
to
Hi,

Is there any command to describe a table in the command line processor.
Meaning showing the field names, data types, null/not null constraints.
In Oracle, the 'describe/desc' keyword is used for this purpose, but in
DB2 the keyword is reserved for something else.

Or using the Command Center is the only way to achieve this?

Thanks a lot.

Adrian

unread,
May 17, 2002, 2:08:29 AM5/17/02
to
Hi!

'describe table Table_name'
It returns column name, type schema and name, lenght, sclae and nulls, but I
can't find any information about this in help.

Regards
Adrian

Gert van der Kooij

unread,
May 17, 2002, 12:29:19 PM5/17/02
to
In article <ac26ni$14f$1...@news.tpi.pl>, adi...@wp.pl says...

> Hi!
>
> 'describe table Table_name'
> It returns column name, type schema and name, lenght, sclae and nulls, but I
> can't find any information about this in help.
>


It's described in the Command Reference :)

0 new messages