SQL Server sp_help = what in in DB2?

[RICHEVAN]

All,

I am new to DB2, and I am using the AS/400 Operationas Navigator which provides a GUI command line interface to issue SQL commands to a DB2 database.

To get a text dump to the SQL Server command line screen of the columns and column types and the indexes and other constraints of a table is possible using the stored procedure sp_help <tablename>.

Can anyone tell me the equivalent command line approach in DB2?

Thanks
Richard

 

[dbmsguy]

you need to do a describe

db2 &quot;describe tablname&quot;

will return a description of the table Paul

http://www.dbmsguy.com