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 + '];'...