how to drop many databases in the same time

[thyra]

dear all,
i have problem in drop database. i have many database and i don't know how to write Query to drop many databases in one statement.i can only drop one by one.
thanks,

[Luuk]

There is no way to write s Query to do a drop database.

this is because a DROP DATABASE is a DDL, and not a DML

BTW: do you really mean DROP DATABASE?, of are you talking about DROP TABLE (which is also DDL) ?