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:
Post a Comment