CheckIfTableExists.sql

/* This sql script checks if table with name TEST_TBL exists.
* The resultset of this query is column name '1' with one row,
* if the row contains a greate than '1' then the table exists.
* If it '0' the table doesn't exist.
*
*/

select count(*) from SYS.SYSTABLES, SYS.SYSCOLUMNS 
        where SYS.SYSTABLES.TABLEID=SYS.SYSCOLUMNS.REFERENCEID 
          and SYS.SYSTABLES.TABLENAME = 'TEST_TBL';