What is the simplest way to modify schema of an existing stored procedure in Sql Server Management Studio?
Use ALTER SCHEMA
to change the schema to your stored procedure without re-creating it:
ALTER SCHEMA newSchema TRANSFER oldSchema.yourStoredProcedure
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With