ALTER TEXT INDEX [ owner.]text-index-name 
ON [ owner.]table-name 
alter-clause

alter-clause : 
rename-object 
| refresh-alteration

rename-object :
 RENAME { AS | TO } new-name

refresh-alteration : 
{ MANUAL REFRESH 
| AUTO REFRESH [ EVERY integer { MINUTES | HOURS } ] }

Once a text index is created, you cannot change it to, or from, IMMEDIATE REFRESH. If either of these changes is required, you must drop and recreate the text index.

Must be the owner of the underlying table, or have DBA authority, or have REFERENCES permission.

This statement cannot be executed when there are cursors opened with the WITH HOLD clause that use either statement or transaction snapshots.

Automatic commit

• CREATE TEXT INDEX statement
• ALTER TEXT INDEX statement
• DROP TEXT INDEX statement
• REFRESH TEXT INDEX statement
• TRUNCATE TEXT INDEX statement
• COMMENT statement
• Snapshot isolation
• Viewing information about a text index in the database (Sybase Central)
• Full text search
• Tutorial: Performing a full text search on a GENERIC text index
• Tutorial: Performing a fuzzy full text search

The first statement creates a text index, txt_index_manual, defining it as MANUAL REFRESH. The second statement alters the text index to refresh automatically every day. The third statement renames the text index to txt_index_daily.

CREATE TEXT INDEX txt_index_manual ON MarketingInformation ( Description ) 
   MANUAL REFRESH;
ALTER TEXT INDEX txt_index_manual ON MarketingInformation 
   AUTO REFRESH EVERY 24 HOURS;
ALTER TEXT INDEX txt_index_manual ON MarketingInformation 
   RENAME AS txt_index_daily;