DB2查看表分区和某表模式的记录数
--查看表分区SELECT * FROM SYSCAT.datapartitions WHERE TABNAME='table_name'--添加表分区alter table table_name add partition statis_month STARTINT'201301' INCLUSIVE ENDING '20090102' INCLUSIVE--查看表模式里面表的记录数select tabname,card from syscat.tables where tabschema .
转载
2021-12-31 14:09:22 ·
3416 阅读 ·
0 评论