hello,

i am connecting to a database from within asp, i need to send a query in order to drop the database completely, can i do this by sending the drop command directly or should i do something else. the problem is i cannot test this now because the db is on and running, but i need to insert a script that drops the database after a while, is this possible?

First rule - never test on a production system, always have a test environment and a production environment. (For scenarios like this)

To answer your question yes, you can send DROP TABLE [table name] directly via a query to execute the command. You could also set up a stored procedure that takes a table name as an argument and execute that as well.



"The one language all programmers understand is profanity."

10x dparsons, i have just done that, now i will be waiting (thanks for the tip also, although i already know it...)

hey dparsons, i forgot about it for a while, but the method you gave me is for deleting tables, what if i want to delete the whole database, ie drop databasename, is it possible?