Deleting a Text Configuration Object

Remove one or more text configuration objects.

Prerequisites
Database Version Text Configuration Object Privileges
SAP Sybase IQ 15.3 and 15.4 Text configuration object owned by self – none.

Table configuration object owned by any user – you must have DBA authority.

SAP Sybase IQ 16.0 Text configuration object owned by self – none.
Table configuration object owned by any user – you must have one of:
  • DROP ANY TEXT CONFIGURATION 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 Configuration Objects.
  3. Select one or more text configuration objects from the right pane and either.
    • Click the arrow to the right of the name and select Delete, or
    • From the Administration Console menu bar, select Resource > Delete.
    Note: You cannot delete the default text configuration objects default_char and or default_nchar.
    Tip: Use Shift-click or Control-click to select multiple text configurations.
  4. Click Yes to confirm deletion.
Related tasks
Creating a Text Configuration Object
Generating Text Configuration Object DDL Commands
Viewing or Modifying Text Configuration Object Properties
Authenticating a Login Account for a Managed Resource
Related reference
Text Configuration Privilege Summary