[quote]
select * from syscat.indexes where tabname = 'T_CHECKLIMIT'
select * from syscat.indexes where tabname = 'T_CHECKLIMIT' and indname = 'SQL171113120118780'
columns可以看到有哪几个column组成这个索引 +YWTAG+CHECKSTH
uniquerule 是表示是不是pk P
ownertype表示是不是唯一 U
http://blog.csdn.net/db2china/article/details/17310159
http://blog.csdn.net/TUBER727/article/details/12564309
[/quote]
select * from syscat.indexes where tabname = 'T_CHECKLIMIT'
select * from syscat.indexes where tabname = 'T_CHECKLIMIT' and indname = 'SQL171113120118780'
columns可以看到有哪几个column组成这个索引 +YWTAG+CHECKSTH
uniquerule 是表示是不是pk P
ownertype表示是不是唯一 U
http://blog.csdn.net/db2china/article/details/17310159
http://blog.csdn.net/TUBER727/article/details/12564309
[/quote]