SE_table_delete_index

Drops a DBMS index.

Usage syntax

SE_table_delete_index
(SE_CONNECTION connection,
const CHAR *table,
const CHAR *index_name);

Parameters
connection The connection handle
table The name of the DBMS table on which the index is created
index_name The name of the DBMS index to delete
Description

SE_table_delete_index deletes a DBMS index for the specified table. Some DBMSs require unique index names within a namespace. Therefore, they do not require a table name to uniquely identify an index. For these DBMSs, you can pass an empty string as the table parameter. Depending on the DBMS, you may need to prefix the index or table name with the owner’s name (e.g., ‘owner.table’ or ‘owner.index’).

Returns

SE_SUCCESS
SE_CONNECTION_IN_USE

SE_CONNECTION_LOCKED

SE_DB_IO_ERROR

SE_INDEX_NOEXIST

SE_INVALID_CONNECTION

SE_INVALID_PARAM_VALUE

SE_INVALID_POINTER

SE_NET_FAILURE

SE_SDE_NOT_STARTED