Procedure documentationSaving SQL Statements or Definitions of Database Objects in a Repository Locate this document in the navigation structure

 

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

  1. In the context menu of the SQL statement or database object, choose Save as...

    Note Note

    If Save as... is not displayed in the context menu, first choose Edit.

    End of the note.
  2. 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 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

More Information

Editing Objects in a Repository

Concepts of the Database System, Repositories