Deleting table using ADO & SQL

Does anyone know if it is possible to delete tables using SQL queries with ADO?

:confused:

VB Code:

cn.Execute "DROP TABLE Table1"

cn = connection object :)

yes u can dierectly execute the drop table query as :

connection.execute("drop table yourtablename")


the table will be deleted.

thnx!