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. 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.