Dropping an Index

To drop a TimesTen index, issue the DROP INDEX SQL statement.

To uniquely refer to an index, an application must specify both its owner and name. If the application does not specify an owner, TimesTen looks for the index first under the user name of the caller, then under the user name SYS.

The following example drops the index named ixid.

Command> DROP INDEX ixid;

All indexes in a table are dropped automatically when the table is dropped.