Dropping Erroneous Tables from Master database

USE master GO DECLARE @tabname sysname , @sql nvarchar(256) DECLARE tab_cur CURSOR FAST_FORWARD FOR SELECT name FROM sysobjects WITH (NOLOCK) WHERE type = 'U' AND ( name LIKE 'L_%' OR name LIKE 'T_%' ) OPEN tab_cur FETCH tab_cur INTO @tabname WHILE @@FETCH_STATUS = 0 BEGIN SET @sql = 'DROP TABLE ' + @tabname EXEC sp_executesql @sql FETCH tab_cur INTO @tabname END CLOSE tab_cur DEALLOCATE tab_cur GO