Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

multiple sql delete

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Multiple sql delete

Multiple sql delete

ResolvedVersion 2016

Manny has attended:
Access Intermediate course
Access Advanced course

Multiple sql delete

hello guys,

Looking to delete lots of test data out of my database. I have written a basic SQL query but it is not running? Syntax error?

DELETE * FROM ABST
DELETE * FROM NAVT
DELETE * FROM PositionT
DELETE * FROM PricingT
DELETE * FROM XoverT;

I dont want to delete the table or lose its struture, just wanted to emtpy the data. it works if i write a query with one line, but was hoping i could do this all in one go?

Manny

RE: multiple sql delete

Hi Manny,

Thank you for the forum question.

Try this:

DELETE * FROM ABST;
DELETE * FROM NAVT;
DELETE * FROM PositionT;
DELETE * FROM PricingT;
DELETE * FROM XoverT;


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Thu 4 Oct 2018: Automatically marked as resolved.

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Action queries

Unlike select queries you cannot use action queries as a data source for the use with forms or reports,as they do not return a dataset that can be read.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.