Trigger deletes...

[Johnny42]

can I delete all records from several tables at once ?
The tables are not related

 

[PHV]

You may consider a Stored Procedure.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[kittyyo]

Did you try
DELETE FROM table1, table2, table3; ?

Anne

 

[Johnny42]

DELETE FROM table1, table2, table3; ?

RESULTS IN ...ERROR "Specify the table containing the records you wantto delete...

 

[fredericofonseca]

You need to do a delete per table

If you need to code this on VB or another language then you may wish to consider the use of a SP as PHV mentioned so that your VB code only executes one SQL statement, and the deletes are all done on the server side.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Johnny42]

thanks fredericofonseca ,
I was just gonna loop the tables in VBA...
I would not know were to start as a SP


Thanks...

 

[fredericofonseca]

What DB maker/version are you using

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Johnny42]

msde

 

[fredericofonseca]

If you don't have something already you will probably need

http://www.asql.biz/DbaMgr/DownLoad2k.shtm

to manage your databases.


As for stored procedures, please search these forums and

http://www.deja.com

and

http://www.microsoft.com

for stored procedures and you will find plenty of information and samples. Then if you have questions please come back to us with some code.


A small sample.

create procedure dbo.deletetables as
delete from mytbl where myfld not = 9999
go
delete from mytbl2 where myfld2 not = 9999
go;

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Johnny42]

Thanks for the info...will give it a try and follow up...