DB2 查询表、索引及视图是否存在

--表
select * from SYSCAT.TABLES where TABNAME like '%表名%' with ur;
--视图
select * from SYSCAT.VIEWS where VIEWNAME like '%视图名%' with ur;
--存储过程
select * from syscat.PROCEDURES where PROCNAME='存储过程名' with ur;
--索引
select * from SYSCAT.INDEXES where TABNAME='表名' with ur;
--查看DB2版本
SELECT service_level, fixpack_num FROM TABLE(sysproc.env_get_inst_info()) as INSTANCEINFO;