Creating a TEXT index

Before you can perform a full text search, you must create a TEXT index on the columns you want to search. A TEXT index stores positional information for terms in the indexed columns

Creating a TEXT index (Sybase Central)

Connect to the database as a user with DBA or RESOURCE authority.
In the left pane, right-click the Text Indexes folder and select New > Text Index.
Select the table on which to create the TEXT index.
Type a name for the TEXT index. Click Next.
Select the column to include in the index. Click Next.
Select the text configuration object to use when processing the data for the TEXT index. Click Next.
For SQL Anywhere tables, in the Specify a Refresh Type dialog, click Next.

For Sybase IQ tables, this option does not appear. The only supported refresh type is Immediate.
Select the dbspace where the TEXT index will be stored.
Click Next.
Type a comment describing the text configuration, and click Finish.

Creating a TEXT index (Interactive SQL)

Connect to the database as a user with DBA or RESOURCE authority.
Execute a CREATE TEXT INDEX statement.

This example creates a TEXT index, myTxtIdx, on the CompanyName column of the Customers table in the iqdemo database. The default_char text configuration object is used.
```
CREATE TEXT INDEX myTxtIdx ON Customers
	( CompanyName ) CONFIGURATION default_char
```