Saving SQL Statements or Definitions of Database Objects in a Repository 
You can save SQL statements and definitions of database objects (such as table definitions) in a repository and reuse them later.
Prerequisites
You have fulfilled one of the following prerequisites:
You have entered an SQL statement in the SQL Editor.
More information: Working with SQL Statements: Overview
You have created a database object and displayed the definition of the database object using the Export SQL command in the context menu of the relevant editor.
Procedure
In the context menu of the SQL statement or database object, choose Save as...
NoteIf Save as... is not displayed in the context menu, first choose Edit.
End of the note.Select the location to which you want to save the SQL statement or definition of a database object.
Database Studio: Repositories Property
Description
My Objects
Objects in the logged-on user's private branch of the repository
Shared Objects
Objects in the public branch of the repository
Local User Folder
Local, user-specific folder in the file system
Example<user_home>\sdb\My Local Folder
End of the example.To change the local user folder, choose
Window 
Preferences Database Studio Repository 
and enter the new location.Packages
Loader directory, used for exporting and importing data
More information: Exporting and Importing: Overview