You could capture the SQL statements in a variable and then execute it:

DECLARE @Sql nvarchar(max);

SET @Sql = '';

SELECT @Sql +='DROP TABLE [' + s.name + '].[' +tab.name + '];'...