SE_table_create_index

Creates a DBMS index on a table.

Usage syntax

LONG SE_table_create_index
(SE_CONNECTION connection,
const CHAR *table,
const CHAR *column,
BOOL unique,
BOOL ascending,
const CHAR *index_name,
const CHAR *config_keyword);

Parameters
connection The connection handle
table The DBMS table name
column The DBMS column name
unique Set to TRUE if index is unique
ascending Set to TRUE if index is ascending
index_name The index name
config_keyword Keyword indicating alternate default configurations. The keyword is found in the dbtune.sde file
Description

SE_table_create_index creates a DBMS index on the specified table. You can also use SE_table_create_indexes .

Returns

SE_SUCCESS
SE_DB_IO_ERROR

SE_INVALID_CONNECTION

SE_INVALID_PARAM_VALUE

SE_INVALID_POINTER

SE_NET_FAILURE

SE_NO_PERMISSIONS

SE_SDE_NOT_STARTED

SE_TABLE_NOEXIST