How to change the schema of stored procedure without recreating it

Question

I have some Stored procedure with "SalesTraining" schema. I want to change all SalesTraining schemas to "Sales". Is there any better way than recreating the stored procedures? thnx

Answer 1

You can use ALTER SCHEMA (Transact-SQL) if you are on SQL Server 2005 or later.

ALTER SCHEMA Sales TRANSFER SalesTraining.MainSP;