Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
In this lesson, you create a table named Products.
For information about designing tables, see Designing the database table properties.
To create a table
In the right pane of Sybase Central, double-click Tables.
Right click the Tables pane and choose New » Table.
In the What Do You Want To Name The New Table field, type Products.
The database server creates the table using defaults, and then displays the Columns tab in the right pane. Each row in the Columns tab defines a column in the table.
In the first column of your table, click PKey and type ProductID in the Name field.
A primary key can comprise several columns concatenated together. For the purposes of this tutorial, however, the primary key contains only one column, which has a value that is automatically incremented for each row added to the table. The autoincrement property ensures that values are unique—a requirement for primary keys. See Primary keys.
In the Data Type list, select Integer.
Click the ellipsis (three dots) button.
Click the Value tab and choose Default Value » System-Defined » Autoincrement
From the File menu, choose New » Column.
Complete the following fields:
From the File menu, choose Save.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|