1.查看表所在的表空间:
select tabname,tbspace from syscat.tables where tabname = ‘表名’;–表名大写
2.查看表的索引:
select * from syscat.indexes where tabname = ‘表名’;–表名大写
db2 查看表所在的表空间以及表的索引的sql
最新推荐文章于 2024-06-01 10:45:50 发布
1.查看表所在的表空间:
select tabname,tbspace from syscat.tables where tabname = ‘表名’;–表名大写
2.查看表的索引:
select * from syscat.indexes where tabname = ‘表名’;–表名大写