1.查看表所在的表空间: select tabname,tbspace from syscat.tables where tabname = ‘表名’;–表名大写 2.查看表的索引: select * from syscat.indexes where tabname = ‘表名’;–表名大写