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.
