Generating Text Index DDL Commands

Generate data description language for one or more text indexes. The DDL code can be a useful reference and training tool.

Prerequisites

Database Version	Text Index Privileges
SAP Sybase IQ 15.3 and 15.4	None required to generate DDL commands; however, requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
SAP Sybase IQ 16.0	None required to generate DDL commands; however, If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes. If the system procedure security model^* of the selected database is set to Invoker, you require one of the following system privileges to display a list of existing text indexes. MANAGE ANY STATISTICS system privilege CREATE ANY INDEX system privilege ALTER ANY INDEX system privilege DROP ANY INDEX system privilege CREATE ANY OBJECT system privilege ALTER ANY OBJECT system privilege DROP ANY OBJECT system privilege ^*The system procedure security model of the selected database appears on the General page of database properties.

Database Version

Text Index Privileges

SAP Sybase IQ 15.3 and 15.4

None required to generate DDL commands; however, requires EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.

SAP Sybase IQ 16.0

None required to generate DDL commands; however,

If the system procedure security model^* of the selected database is set to Definer, you require EXECUTE permission on the sa_text_index_stats system procedure to display a list of existing text indexes.
If the system procedure security model^* of the selected database is set to Invoker, you require one of the following system privileges to display a list of existing text indexes.
- MANAGE ANY STATISTICS system privilege
- CREATE ANY INDEX system privilege
- ALTER ANY INDEX system privilege
- DROP ANY INDEX system privilege
- CREATE ANY OBJECT system privilege
- ALTER ANY OBJECT system privilege
- DROP ANY OBJECT system privilege

^*The system procedure security model of the selected database appears on the General page of database properties.

The SAP Sybase IQ resource is authenticated and running.
You are licensed for the Unstructured Data Analytics option (IQ_UDA).

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the left pane, select IQ Servers > Schema Objects > Text Index.
Select one or more text indexes from the right pane and either:
- Click the arrow to the right of the name and select Generate DDL, or
- From the Administration Console menu bar, select Resource > Generate DDL.
The DDL view shows the SQL code used to add the selected text indexes to the database.