Did you know that your ASP scripts can do a lot more then just
retreive data from your database? Writing a page that will
create or delete tables is really no harder then writing a
page to run a query.
You need to make sure you've got the appropriate permissions,
but, assuming you do, you can easily create, delete, or modify
tables in your database. Take a look at this sample code:
The magic is all in the SQL... besides that it looks just
like any other DB-based ASP file. The next time you're
looking for a way to make a small change to your database,
this type of thing might just do the trick. Be careful
though... with all this power, one wrong step and you could
lose your tables and their data.
That's the problem with computers... they
tend to do what you tell them to, not necessarily
what you want them to! ;)