Pasted

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