Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.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 running the command.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

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