I have a bunch of stored procedure(more than 200) in my database.
I have to change the schema of those now. They have the schema ABC. I have to change it to XYZ,.
I know [ALTER SCHEMA XYZ TRANSFER ABC.STOREDPROCEDURE] query would do.
But the no of stored procedure is huge . I cannot do one by one. Is there any other way to do this task.