Transfer SQL Server Objects to another schema.

transfer_objects_to_dbo_schema.sql

SELECT 'ALTER SCHEMA dbo TRANSFER ' + s.Name + '.' + o.Name
FROM sys.Objects o
INNER JOIN sys.Schemas s on o.schema_id = s.schema_id
WHERE s.Name = 'your_schema_name'
And (o.Type = 'U' Or o.Type = 'P' Or o.Type = 'V')

transfer_tables_to_dbo_schema.sql

EXEC sp_MSforeachtable "ALTER SCHEMA dbo TRANSFER ? PRINT '? modified' "