To create a text index (Sybase Central)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which you are creating the text index.

2. In the left pane, click Tables.

3. Double-click the table on which you want to create a text index.

4. Click the Text Indexes tab.

5. Choose File » New » Text Index.

   The Create Index Wizard appears.

6. Follow the instructions in the wizard.

   The new text index appears on the Text Indexes tab. It also appears in the Text Indexes folder.

To create a new text index (SQL)

1. Connect to the database as a user with DBA authority, or as the owner of the table on which you are creating the text index.

2. Execute a CREATE TEXT INDEX statement.

   For example, the following statement creates a text index called txt_index_manual on the Description column of the Products table in the demo database:

   CREATE TEXT INDEX txt_index_manual ON Products ( Description ) MANUAL REFRESH;

   Since the text index is defined as MANUAL REFRESH, you need to refresh it using the REFRESH TEXT INDEX statement.