Change the name of a text index, or change its refresh type.
To alter a text index on a table, you must be the owner of the table or have one of the following privileges:
To alter a text index on a materialized view, you must be the owner of the materialized view or have one of the following privileges:
You cannot alter a text index to refer to a different text configuration object. If you want a text index to refer to another text configuration object, drop the text index and recreate it specifying the new text configuration object.
You cannot change a text index to, or from, IMMEDIATE REFRESH; to make this change, you must drop the text index and recreate it.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
In the left pane, click Text Indexes.
Right-click the text index and click Properties.
Edit the text index properties.
You can rename the text index on the General tab.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|