Databases Editor (Sybase ASE)

From RapidSQL
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Databases Editor lets you manage properties, placement, and binds for a database as well as view associated space statistics.

To edit a database

  1. Open an editor on the database. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

For information on working with these settings, see Databases (Sybase ASE) - Properties.

Placement

Displays device fragments. Optionally you can:

Select a fragment to view the Device Name, Size, and Device Type (DATA AND LOG or DATA ONLY) for the fragment.

Click the New button to open a dialog that lets you provide the data device and log device details for a new database fragment. NOTE: We strongly recommend that you place the transaction log on a separate device from all other database fragments.

Space

Lets you view pie charts showing the data space usage and the transaction log (if available) space usage for the database.

Bindings

This tab is only available for databases created with a Type of TEMP. It displays all applications or logins bound to the database. Optionally, you can:

Bind another application or login to the database by selecting the APPLICATION or LOGIN folder as appropriate, clicking Add, and in the dialog that opens select a login or provide an application name.

Remove bindings by selecting the specific application or login and clicking Drop.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.
Personal tools