Friday, December 14, 2007

How to delete a table from database?

How to delete a table from database?

We can use the "Execute" method in the ADO connection to delete the table from database:

<%

Set conn = Server.CreateObject("Adodb.Connection")

conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("db1.mdb")

conn.execute "DROP TABLE master"

'DROP TABLE master - Select the table that you want to delete.

%>

No comments: