Using If exists drop table in Apache Derby and CF8

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

http://fusecf.blogspot.com/2007/08/coldfusion-8-and-derby-db-create-and.html

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.