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