You can copy a script in the Script Repository by saving it with a new name.
To copy a script:
Click the SQL Workshop icon on the Workspace home page.
Click the SQL Scripts icon.
Load the script to copy into the editor.
Enter a name for the copied script in the Script Name field.
Click Save to save a copy of the script in the Script Repository.
The SQL Scripts home page appears listing the newly copied script.