Primary Keys Editor (Sybase ASE)

From RapidSQL
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Primary Keys Editor lets you manage the columns that make up the primary key and its basic properties, as well as view statistics for the primary key.

To edit a primary key

  1. Open an editor on the primary key. 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

Columns

Lets you manage columns that make up the primary key. On opening, this tab shows the existing columns. For each column, the datatype (and if applicable the precision in brackets) and whether the table definition permits nulls in the target table column. Optionally you can:

Change the Sort order of a column.

Click the New button and select a column name from the dropdown, to add a column to the primary key.

Select a column and click the Drop button to delete the column from the primary key.

Select a column and use the arrow buttons to reorder the columns in the primary key.

Properties

Lets you work with settings in the following categories:

Attributes

Lets you set the Clustered and Maximum Rows Per Page properties.

Storage

Lets you set Reserve Page Gap, Segment (DEFAULT, LOGSEGMENT or SYSTEM), and Fill Factor properties.

Statistics

Lets you view statistics in the following categories:

Page Statistics

Data Pages, Reserved Pages, Used Pages, OAM Page Ratio, and Index Page Ratio.

Row Statistics

Maximum Row Size, Minimum Row Size, Max Size of Non-Leaf Index Row, and Maximum Rows Per Page.

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