USE your_db_name

DECLARE schema_table CURSOR FOR
SELECT 
	t.name AS table_nm, 
	s.name AS schema_nm
FROM 
	sys.tables t inner join sys.schemas s ON t.schema_id = s.schema_id
WHERE
	s.name = 'offending schema name'
ORDER BY
	t.name

DECLARE @tbl_nm	nvarchar(50), 
		@sch_nm	nvarchar(50)

OPEN schema_table 
FETCH NEXT FROM schema_table INTO @tbl_nm, @sch_nm

WHILE @@FETCH_STATUS = 0  
    BEGIN  

	EXEC('ALTER SCHEMA dbo TRANSFER ' + @tbl_nm)
	
	FETCH NEXT FROM schema_table INTO @tbl_nm, @sch_nm
    END  
CLOSE schema_table
DEALLOCATE schema_table