How can I delete a table?

[fergman]

I'm trying to do a simple removal of a table, and after my handy dandy book I came up with a drop table statement that looks like this, but it doesn't work:

SQL = "DROP TABLE " & companyName & ""
Rs.Open SQL, outsales, 1,3

It gives me a Syntax error. I've never even had the need to delete a table before, but now I do. it's possible isn't it?
companyName is a vbscript variable passed from the previous page.

 

[BDC2]

Set editCmd = Server.CreateObject("ADODB.Command&quot
editCmd.ActiveConnection = ConnectionString
editCmd.CommandText = "DROP TABLE " & companyName
editCmd.Execute
editCmd.ActiveConnection.Close
Set editCmd = nothing

BDC.

 

[baddos]

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.Open "some connection string"
objConn.Execute("DROP TABLE '" & companyName & "'&quot
objConn.Close
Set objConn = Nothing

 

[BDC2]

;-)

BDC.

 

[Genimuse]

Which is to say that if you're not requesting a recordset but are instead issuing a command, you use command objects and syntax, not recordset objects and syntax.