2012年10月4日 星期四
[DB2] Table Schema
1. Show all index
SELECT * FROM SYSIBM.SYSINDEXES WHERE TBNAME='TABLE NAME'
The column UNIQUERULE:
D = means duplicate allowed P = means primary index U = means unique index
2. Show all columns
SELECT * FROM SYSIBM.SYSCOLUMNS WHERE TBNAME='TABLE NAME'
訂閱：
文章 (Atom)