Re: [MonetDB-users] DROP TABLE IF EXISTS <table>;

On 30-03-2011 16:41:15 +0300, Michael Sioutis wrote:

I want to prevent an SQLException from?occurring?for tables that do not exist in my database.

For example:

sql>DROP TABLE "locked";

SQLException:sql.catalog:DROP TABLE: no such table 'locked'

It seems (and is documented) that there is no such thing like "IF EXISTS" in MonetDB.

Is there a way to circumvent the SQLException?

no. However, you could just check if the table exists by looking it up with a query, if that helps you from your application.