Tables Editor (Sybase ASE)

From DBArtisan
Jump to: navigation, search

Go Up to Sybase ASE Object Editors

The Tables Editor lets you manage columns, basic properties, constraints, storage and space, and partitions of a table.

To edit a table

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

Displays the currently defined columns in the table. For any selected column, the Property/Value list provides additional detail on that column. Available properties depend on the datatype you choose as well as on the property values you select: Computed and Computed Expression - Let you define a column as a computed column and provide the computed column expression. Type - Lets you select a datatype (depending on the type, additional properties such as Size, Width, and Scale may be available). Identity Column - Select this check box to define the column as an identity column. Allow Nulls - Select this check box to allow nulls in this column. Default Collation - available for text/character datatypes, lets you specify a default collation. Default Value - Lets you type a constant value or select a function returning a constant value to serve as the default for the column Default Binding and Rule Binding - Let you bind a rule or default to a column. Optionally, you can:

Select a column, and in the Property/Value list modify property values for that column.

Click Add Column, provide a name for the new column, and set property values for the column.

Select a column and click Delete to remove the column from the table.

Properties

Lets you work with properties in the following categories:

Physical Storage

Lets you set the Segment Name (DEFAULT, SYSTEM), Maximum Rows Per Page, Reserve Page Gap, and Identity Gap properties.

Cache Strategy

Lets you set MRU Replacement Strategy and Prefetch Strategy properties.

Row Locking Strategy

Lets you view the Expected Row Size property and set the Lock Scheme (ALLPAGES, DATAPAGES, ROWPAGES) property.

Indexes

Lets you manage indexes for a table. On opening, the list of current indexes for the table is displayed. Optionally, take one of the following actions:

Click Add to open a dialog that lets you add a new index to the table.

Select an index and click Edit to open a dialog that lets you edit index properties.

Select an index and click Drop to open a dialog that lets you remove the index from the table.

Constraints

Lets you manage constraints for the table. Constraints are grouped by type, under folders. Optionally take one of the following actions:

Select a constraint type folder and click Add to open a dialog that lets you add a constraint of that type.

Select a constraint and click Edit to open a dialog that lets you modify the constraint details.

Select a constraint and click Drop to remove the constraint.

Space

Lets you view the table usage and the distribution of table space for a table. Optionally, double-click a slice in the pie chart for detailed statistics.

Partitions

Displays partition details for the table including the Partition Type (ROUNDROBIN, HASH, LIST, RANGE), partitioning Columns (name and datatype) and Partition Definitions (Name, values, segments). You can also add or modify partition definitions. For more information, see Partitioning Sybase ASE Tables.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

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.

Partitioning Sybase ASE Tables

The Create Partition and Edit Partition wizards let you work with table partitions.

To create or edit table partitions

  1. Open an editor on a table. For details, see Opening an Object Editor.
  2. On the Partition tab, click the Create Partition or Edit Partition button.
  3. Use the following table as a guide to understanding and modifying the settings on the tabs of this wizard:
Tab Settings and tasks

Properties

In addition to displaying basic identification and ownership properties, this pane lets you select a Partition Type (ROUNDROBIN, HASH, LIST, RANGE).

Columns (not available for a Partition Type of ROUNDROBIN)

For each column to be added, click New to add a column and select a Column name.

Range Definitions (only available for a Partition Type of RANGE)

Lets you create an ordered list of partitions. For each partition, click New to open the Add Partition Definition wizard. Provide a Name, select a Segment, (DEFAULT, SYSTEM, LOGSEGMENT) and click Add. The Range Definitions pane also lets you edit and remove partitions.

Partitions Definitions (only available for a Partition Type of HASH)

Lets you specify a Partition method: None Number of Partitions - Specify a Number of Partitions, and then for each partition, click the New button and select a segment. By Partition Name - For each partition, click New, specify a Name and select a Segment.

List Definitions (only available for a Partition Type of LIST)

Lets you create a list of partition definitions. For each partition, click New to open the Add Partition Definition wizard. Provide a Name, select a Segment, (DEFAULT, SYSTEM, LOGSEGMENT) and click Add. The List Definitions pane also lets you edit and remove partitions.

4. When ready, click Finish.