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, you must have 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, you must also have EXECUTE permission on the sa_text_index_stats system procedure 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
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects, and then select Text Indexes.
  3. 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.
Parent topic: Text Indexes
Related tasks
Creating a Text Index
Deleting a Text Index
Refreshing a Text Index
Truncating a Text Index
Viewing or Modifying Text Index Properties
Authenticating a Login Account for a Managed Resource
Related reference
Text Index Privilege Summary