Change DB Schema.

Select 'Alter Schema dbo Transfer ' + [s].name+'.'+o.name from
sys.schemas s inner join sys.objects o on s.schema_id = o.schema_id
and s.name = 'schema_name'

credits -  pramod