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
