Chapter 3 Building Physical Diagrams

Creating a user-defined index

You create an index from the list of indexes in a table property sheet. You can select index columns in the columns page and click the Create Index tool to quickly create an index on selected columns.

To create a user defined index:

1. Double-click the table in the diagram to display the table property sheet.
2. Click the Indexes tab.
   
   The Indexes page appears. It lists indexes associated with the table.
3. Click a new line in the list
   
   or
   
   Click the Add a Row tool.
   
   An arrow appears at the beginning of the line.
4. Type an index name and an index code.
   
5. Click the Properties tool.
   
   or
   
   Double-click the arrow at the beginning of the line.
   
   The index property sheet opens to the General page.
6. Type or select index properties.
7. Click the Columns tab.
   
   The Columns page appears. It lists columns associated with the index. At index creation the list is empty as there are no columns yet associated with an index.
8. Click the Add a Row tool.
   
   A list of columns defined for the table appears.
9. Select one or more columns.
   
   Click OK.
   
   You return to the Columns page. The columns associated with the index appear in the column list.
10. Select Ascending or Descending in the Sort column.
11. Click OK in each of the dialog boxes.

Copyright (C) 2005. Sybase Inc. All rights reserved.