Home Forums SQL Server 2005 Administering Replacing Schema with new schema of Database objects RE: Replacing Schema with new schema of Database objects

  • 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)