SQL Server allows you to remove multiple tables at once using a single DROP TABLE statement as follows