Dropping an Index

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

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.
   • Escaped names are not supported.
     Note: In SQL, an escaped name is a sequence of one or more characters enclosed within SQL escape characters. Trailing spaces are insignificant. An escaped name is case sensitive and special characters used within the escaped name must themselves be escaped.
   • Object names (for example, <index_name>, and <table_name>) are case insensitive. ActiveSpaces converts all object names to lowercase prior to executing the command.