Creating and modifying a primary key (Sybase Central)

You can create or modify a primary key for a table using Sybase Central. Primary keys can improve performance for any operation that involves querying data.

Prerequisites

You must have DBA authority, owner of the table, or have permissions to modify the table.

Context and remarks

You are adding a primary key to improve performance, or altering a primary key to reflect changes in the underlying objects that the key references.

 Configure a primary key using Sybase Central

  1. Connect to the database using the SQL Anywhere 12 plug-in.

  2. In the left pane, double-click Tables.

  3. Right-click the table and click Set Primary Key.

  4. Follow the instructions in the Set Primary Key Wizard.

Results

The table definition is modified to include updated primary key information.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1