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.
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.
Connect to the database using the SQL Anywhere 12 plug-in.
In the left pane, double-click Tables.
Right-click the table and click Set Primary Key.
Follow the instructions in the Set Primary Key Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|