Databases Editor (Sybase ASE)

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.