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;

1	ALTER SCHEMA destinationSchema TRANSFER sourceSchema.storedProcedure;

Posted

February 26, 2013

Rose Bush

Tags:

Comments