how can drop multiple table in sql server

Question

Jignesh Trivedi · Answer

hi please read my article http://www.c-sharpcorner.com/UploadFile/ff2f08/delete-all-table-data-within-a-database-in-sql-server/ here instead of delete query you can write drop table query. hope this will help you.

Vikrant More · Answer

you can use exec sp_MSforeachtable 'drop table ?' this will drop all tables. if you want to drop only few table you can write cursor to drop it.

Nanhe Siddique · Answer

hi for dropping multiple table use this drop table tablename1tablename2tablename....N.