db2 查看表所在的表空间以及表的索引的sql

mac2025-10-31  17

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

最新回复(0)