LeGrand,
There is a db2 utility called db2look which will give you more than you need, 'db2look ?' for help. Here is an example using the SAMPLE database: db2look -d sample -u db2inst1 -o lookout.txt -e -l -x Regards, Rob Arthur IBM Certified Solutions Expert - DB2 UDB V6.1 Database Administration Sr. I/T Specialist IBM Global Services Global Smart Card Solutions "LeGrand Decius" <[EMAIL PROTECTED]>@lists1.ba.best.com on 10/11/2001 12:17:55 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: DB2EUG: Table Properties Is there a quick command to print DB2 table properties. I would like to display similar information as the alter command (fieldname, type, primary keys, index). Information similar to a ddl statement but with more detail for the specified table. Thank you in advance. LeGrand Decius. ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
