Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

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

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.