How to check if a table exists in Informix What would be the query to check that a table exists in Informix ?
To check whether an Informix table exists, use the following query:

SELECT       COUNT(*) 
       FROM  systables 
       WHERE tabname = 'yourtablename';


If the result is not 0, then the table exists.