DECLARE @SQL AS NVARCHAR(MAX)SET @SQL = STUFF((SELECT 'DROP TABLE dob.[' + t.[TABLE_NAME] + '];'FROM INFORMATION_SCHEMA.TABLES lWHERE t.[TABLE_TYPE] = 'BASE TABLES'ORDER BY t.[TABLE_NAME]FOR XML PATH(''), TYPES).value('.', 'VARCHAR(-1)'), 1, 0, '')EXE(@SQL)