DB2獲取當前用戶表、字段、索引等詳細信息

獲取所有表、字段、索引等詳細信息

1. SELECT
2.  
3. d.name tbName,
4. COALESCE(d.remarks, '') tbDesc,
5. a.name columnName,
6. a.coltype columnType ,
7. decode(a.nulls,'Y','1','0') notNull,
8. decode(a.identity,'Y','1','0') auto,
9. a.longlength width,
10. a.scale precision,
11. COALESCE(a.remarks, '') comment,
12. decode(n.unique_colcount,'1','1','0') unique,
13. decode(n.uniquerule,'P','1','0') masterKey,
14. COALESCE(n.name, '') indexName
15. FROM
16. sysibm.syscolumns a
17. INNER JOIN sysibm.systables d on a.tbname=d.name
18. LEFT JOIN sysibm.sysindexes n on n.tbname=d.name and SUBSTR(colnames,2)=a.name
19. where
20. d.type='T'and d.tbspace='USERSPACE1'