db2查询表索引的sql语句

时间：2025-04-02 09:02:14

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

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