List:General Discussion« Previous MessageNext Message »
From:roger.maynard Date:August 15 2008 9:20am
Subject:DROP TABLE IF EXISTS - doesnt??
View as plain text  
I am finding that 

 

DROP TABLE IF EXISTS mytable;

 

Works fine if the table exists - but if it doesn't exist I get an error?


 

Surely it should not error and just not try to drop the table.

 

Is it me?


Thread
DROP TABLE IF EXISTS - doesnt??roger.maynard15 Aug
  • Re: DROP TABLE IF EXISTS - doesnt??Fish Kungfu15 Aug
RE: DROP TABLE IF EXISTS - doesnt??roger.maynard15 Aug
  • RE: DROP TABLE IF EXISTS - doesnt??Martin Gainty15 Aug
RE: DROP TABLE IF EXISTS - doesnt??Fish Kungfu15 Aug