17 August 2009

Using If exists drop table in Apache Derby and CF8

All credit to Giancarlo Gomez for this blog post, awesome:


Using apache derby as a testing database is really useful and this article describes a great method of checking if a table exists and dropping it or re-creating it.

I find it very useful when testing and developing a new site to create a cfm page that just drops all tables and re-creates them with new data in. This saves a lot of time fiddling when you suddenly decide you need a new column or something.

No comments: