u011498933的专栏

--查看表分区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 .