Describe all tables in a database

I use the following describe command to obtain the information from a single table:

Describe Select * from employee

How would I gather the same information from ALL tables with a single command?

Thanks,

stevechism-at-gmail.com wrote:

> I use the following describe command to obtain the information from a single table:
>
> Describe Select * from employee
>
> How would I gather the same information from ALL tables with a single command?
>
> Thanks,
Hi,

Actually, you shouldnt have to do the select. Here is how I typically
use describe:

describe table employee

To answer your questions, you could use the db2look command with the -e
option (I usually get annoyed by the default postscript output when -e
is not used).

Regards,
Kenneth

In article
<1454710998.1136902878374.JavaMail.wassrvr@ltsgwas0 07.sby.ibm.com>,
(stevechism-at-gmail.com) says...
> I use the following describe command to obtain the information from a single table:
>
> Describe Select * from employee
>
> How would I gather the same information from ALL tables with a single command?
>
> Thanks,
>

Query the SYSCAT.COLUMNS table