Dropping an Index

Use the SQL command DROP INDEX to remove a secondary index from a table in the data grid.

    Procedure
  1. Compose a string with the following format:
    DROP INDEX [IF EXISTS] <table_name>.<index_name>
  2. Pass the string to the ExecuteUpdate method of the tibdgSession object.

    For example:

    DROP INDEX table1.index1
    DROP INDEX IF EXISTS table1.index1

    Note the following points when using the DROP INDEX command:

    • Primary keys cannot be dropped. Only secondary indexes can be dropped.
    • Object names (for example, <index_name>, and <table_name>) are case insensitive. ActiveSpaces converts all object names to lowercase before executing the command.