1、查询mysql相应数据库中是否存在某个表
sql = "select `TABLE_NAME` from `INFORMATION_SCHEMA`.`TABLES` where `TABLE_SCHEMA`='"+databaseName+"' and `TABLE_NAME`='t_yhxxb'";
2、查询mysql相应数据库中是否存在某个外键
sql = "SELECT CONSTRAINT_NAME FROM information_schema.REFERENTIAL_CONSTRAINTS where CONSTRAINT_SCHEMA='"+databaseName+"' and CONSTRAINT_NAME='fk_jsgn_jsdm'";
3、查询sqlserver相应数据库中是否存在某个表
sql = "select * from sysobjects where id = object_id('"+databaseName+".dbo.t_yhxxb')";
此处的表名也可为外键名或触发器等的名称。
4、查询oracle数据库中是否存在某个表
SELECT count(*) FROM all_tables t WHERE t.table_name=upper('es_log_systemlog_201306');