lame-o. well, that's why i asked first.
Dave wrote:
I'm not opposed to IF EXISTS but only if we can do it in a
cross-database way. It's not supported in PostgreSQL, Derby or Oracle.
So if you want to add it, I guess you'll need a separate
droptables.sql script for MySQL.
- Dave
On 12/6/06, Allen Gilliland <[EMAIL PROTECTED]> wrote:
anyone know if the sql syntax for "drop table if exists <tablename>" is
standard across all dbs? i would like to update our drop tables script
because i tend to get my test dbs in a strange state from time to time
where not all the tables are dropped and the current script dies when it
tries to drop a table that doesn't exist :/
so, anyone opposed to updating the droptables script to include "if
exists"?
-- Allen
