Update the Schema on a Stored Procedure

To update the schema of a single stored procedure, once on the database in question, you would need to run the following line:

ALTER SCHEMA destinationSchema TRANSFER sourceSchema.storedProcedure;