1.列出当前schema的所有表:
D:\Documents and Settings\lsq>db2 list tables|more
表/视图
模式 类型 创建时间
------------------------------- --------------- ----- --------------------------
ACT LSQ T 2009-02-14-13.22.08.515010
ADEFUSR LSQ S 2009-02-14-13.22.12.546001
BUFFERPOOL_TEST1 LSQ T 2009-02-18-20.35.25.968001
CATALOG LSQ T 2009-02-14-13.22.23.703001
CL_SCHED LSQ T 2009-02-14-13.22.05.562001
CONNHEADER_TEST1 LSQ T 2009-02-18-20.35.25.890001
CONTROL_TEST1 LSQ T 2009-02-18-20.35.26.015000
CUSTOMER LSQ T 2009-02-14-13.22.22.015006
DBMEMUSE_TEST1 LSQ T 2009-02-18-20.35.26.031001
DB_TEST1 LSQ T 2009-02-18-20.35.24.796000
DEADLOCK_TEST1 LSQ T 2009-02-18-20.35.25.625001
DEPARTMENT LSQ T 2009-02-14-13.22.05.937001
DEPT LSQ A 2009-02-14-13.22.07.015004
DLCONN_TEST1 LSQ T 2009-02-18-20.35.25.656001
EMP LSQ A 2009-02-14-13.22.07.296004
EMPACT LSQ A 2009-02-14-13.22.08.515005
EMPLOYEE LSQ T 2009-02-14-13.22.07.015006
2.列出指定schema的所有表:
D:\Documents and Settings\lsq>db2 list tables for schema sysstat
表/视图
模式 类型 创建时间
------------------------------- --------------- ----- --------------------------
COLDIST SYSSTAT V 2009-02-14-13.21.45.437003
COLGROUPDIST SYSSTAT V 2009-02-14-13.21.45.500007
COLGROUPDISTCOUNTS SYSSTAT V 2009-02-14-13.21.45.500011
COLGROUPS SYSSTAT V 2009-02-14-13.21.45.500003
COLUMNS SYSSTAT V 2009-02-14-13.21.45.453003
FUNCTIONS SYSSTAT V 2009-02-14-13.21.45.515003
INDEXES SYSSTAT V 2009-02-14-13.21.45.531003
ROUTINES SYSSTAT V 2009-02-14-13.21.45.531007
TABLES SYSSTAT V 2009-02-14-13.21.45.531011
3.查看表结构
D:\Documents and Settings\lsq>db2 describe table sales
数据类型 列
列名 模式 数据类型名称 长 小数位 NULL
------------------------------- --------- ------------------- ---------- ----- ------
SALES_DATE SYSIBM DATE 4 0 是
SALES_PERSON SYSIBM VARCHAR 15 0 是
REGION SYSIBM VARCHAR 15 0 是
SALES SYSIBM INTEGER 4 0 是
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10972173/viewspace-578387/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10972173/viewspace-578387/