how can drop multiple table in sql server

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.

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.

hi, 

for dropping multiple table use this

drop table tablename1,tablename2,tablename....N.