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

Reply via email to