Loading...


You can run the following, which will generate a set of ALTER SCHEMA statements for Table and Procedure:

For Table

ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName;


For Procedure

ALTER SCHEMA TargetSchema TRANSFER SourceSchema.ProcedureName;