How can I tell if a temp table exists before dropping

[martindavey]

I have tried drop table if exists myTable
but this is a syntax error.

I am using Informix.

Any ideas?

 

[Tim1]

Hiya,

You should be able to do:

IF OBJECT_ID('my_table') IS NOT NULL
DROP TABLE my_table


HTH

Tim