Pavle Crnković
Reputation: 23
Informix 11.5 alternative to "drop if exists"
I'm using Informix 11.5 and I'd like to know if there is any alternative to DROP TABLE IF EXISTS <table_name>, since this is not supported in version 11.5.
Upgrade from 11.5 is not an option.
Upvotes: 2
Views: 558
Answers (1)
Jonathan Leffler
Reputation: 754480
The only alternative to DROP TABLE IF EXISTS is a plain DROP TABLE and ignore the error complaining about the table not existing — other errors still need to be worried about.
Upvotes: 1
Related Questions
- Unload statement
- How to add an additional fake null column to select result in Informix?
- Drop a foreign key constraint between columns of two tables without knowing the foreign key name in Informix?
- How to create CHECK constraints in Informix?
- How to use if statement within where clause in INFORMIX?
- Insert into a Informix table or update if exists
- Informix procedure — how to return an empty table?
- NOT EXISTS query doesn't work on Informix while same query with NOT IN works
- JDBC: Alternative of statement.cancel() in Informix DB?
- informix check if table exists and then read the value