I want to delete from multiple table in a single statement h

Question

I want to delete from multiple table in a single statement how will I do it?

Khargesh Rajput · Answer

Use stored procedure and write multiple.query

Jignesh Trivedi · Answer

hi Read my article http://www.c-sharpcorner.com/UploadFile/ff2f08/delete-all-table-data-within-a-database-in-sql-server/ it might help you.

Vikrant More · Answer

you can use exec sp_MSforeachtable 'your delete query' example for select like  exec sp_MSforeachtable 'select count(1) from ?'.

Pankaj Kumar Choudhary · Answer

If All tables are related to each other then you can use concept of foreign and primary key . You can also use a trigger for deletion or use stored procedure according your requirements