CODEWITHSUNDEEP
c#ms-accessadoms-access-2000
Big Pimpin
Big Pimpin

Reputation: 437

ADO To Drop A Query

I know you can use Drop Table to drop a table, but is their a way to delete a query? I'd prefer to use ADO and not DAO to achieve this, if that is possible, as with DAO you have to open the database and ADO you do not.

Upvotes: 1

Views: 72

Answers (1)

HansUp
HansUp

Reputation: 97131

Depending on the type of query, use either DROP VIEW or DROP PROCEDURE.

DROP VIEW should work for a simple SELECT query. Use DROP PROCEDURE with other query types.

Upvotes: 2

Related Questions