delete from (multiple tables)

[marcuscoker]

Hi

Was wondering if anybody can help with this

I would like to create a view/stored procedure whereby i can delete the contents of multiple tables in one view

something like this

delete from table_a
delete from table_b

this does not appear to work and i was wondering if anybody could please point me in the write direction. The tables are not linked, i would just like to run the SQL to delete contents of all tables before i run a DTS package to import data into them

Thanks

Marcus

 

[pdx_man]

Did my suggestion in your previous post not work? Should have ... I do it all the time.

BTW, you cannot Delete data in Views. They are just what they say they are, views into your (usually) tables.