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 .