查询数据库指定表是否存在

 MYSQL：
            select count(*) as tabcount from INFORMATION_SCHEMA.TABLES where TABLE_SCHEMA='dbname()' and TABLE_NAME='tablename‘
 MSSQL：
            select count(*) as tabcount from tempdb.dbo.sysobjects where id = object_id(N'tablename') and type='U'
 ORACLE：
            select count(*) as tabcount from dba_tables where table_name='tablename'
  DB2：
             select count(*) as tabcount from syscat.tables where tabname = upper('tablename')
  SYBASE：
             select count(*) as tabcount from sysobjects where name='tablename' and type='U'
  DM：
             select count(*) as tabcount from sysobjects where name='tablename' and type='U'