DB2常用汇总
一、判断是否存在
查看表select count(*) from syscat.tables where tabschema='yourschema' and tabname='yourtablename' and type='T'select tabname from syscat.tables where tabname= 'your_table_name '查看索引select * from syscat.indexes where tabname = upper('tablename')查看外键select * from SYSCAT.REFERENCES where tabname = upper('tablename')查看触发器select * from SYSCAT.TRIGGERS where tabname = upper('tablename')