1.查看所有表
sp_tables
2.查询某表分区个数
select * from sp_iqdbspaceobjectinfo() where object_name = ‘表名’
3.查询所有的分区表
select * from sp_iqtable() where isPartitioned=’Y’
4.查询分区详情
select * from sp_iqobjectinfo() where object_type=’partition’
5.根据表名和分区名查询
select * from sp_iqobjectinfo() where object_name=’表名’ and sub_object_name=’分区名’
关于Sybase iq常用命令
最新推荐文章于 2021-03-31 11:12:52 发布