[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

DELETE/DROP VIEW

Posted on 2000-01-22
3
Medium Priority
?
127 Views
Last Modified: 2013-11-20
I need to DELETE/DROP VIEW in ODBC/mdb. I tried the following.

db.ExecuteSQL("DROP VIEW add1;");

I get a syntax error: "Syntax error in Drop Table or Drop Index"

Any Ideas?
0
Comment
Question by:rgcomm
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
inpras earned 80 total points
ID: 2378891
U cannot use DROP VIEW instead use DROP TABLE like this
also remove semi colon in the end
db.ExecuteSQL("DROP TABLE add1");
U cannot use DROP VIEW
Hope this helps
0
 

Author Comment

by:rgcomm
ID: 2378915
Works great. I love this forum.

Thanks, your the greatest.
0
 
LVL 4

Expert Comment

by:inpras
ID: 2378949
Wel come
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: Displaying information on the statusbar.   Continuing from the third article about sudoku.   Open the project in visual studio. Status bar – let’s display the timestamp there.  We need to get the timestamp from the document s…
Introduction: Dialogs (1) modal - maintaining the database. Continuing from the ninth article about sudoku.   You might have heard of modal and modeless dialogs.  Here with this Sudoku application will we use one of each type: a modal dialog …
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question