This is your answer my friend 🙂
sp_msforeachtable 'ALTER SCHEMA test TRANSFER ?'
this will change the schema to test .You can change it to employee.
make sure you are in the right database context.
Regards
Abhay Chaudhary
Sr.DBA (MCITP/MCTS :SQL Server 2005/2008 ,OCP 9i)