Data Warehousing Community Forum

Databases => IBM DB2 => Topic started by: Allegra on January 28, 2010, 11:56:23 am



Title: Equivalent Describe command in DB2
Post by: Allegra on January 28, 2010, 11:56:23 am
Please show me up equivalent command for 'Oracle' Describe command in DB2 ?

I seach of this, but no luck..!  ::)


Title: Re: Equivalent Describe command in DB2
Post by: Whoever on January 29, 2010, 05:37:40 pm
DESCRIBE Command (http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002019.htm) ?

Although it doesn't appear to be as universal as the same command is in Oracle.


Title: Re: Equivalent Describe command in DB2
Post by: ragjeevan on February 18, 2010, 01:00:01 pm
It is

Describe table <Table Name>

Checkout for Whoever's reply more details -
DESCRIBE Command (http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002019.htm) ?

Moderator -  No Spamming