SE_table_create_indexes

Creates DBMS indexes on a table.

Usage syntax

LONG SE_table_create_indexes
(SE_CONNECTION connection,
const CHAR *table,
SHORT num_indexes,
SE_INDEX_DEF
*index_defs,
const CHAR *config_keyword);

Parameters
connection The connection handle
table The DBMS table name
num_indexes The number of indexes to create
index_defs A pointer to an SE_INDEX_DEF structure
config_keyword Keyword indicating alternate default configurations. The keyword is found in the dbtune.sde file
Description

SE_table_create_indexes creates one or more DBMS indexes on the specified table. Use SE_INDEX_DEF whose structure is

typedef struct {

     SHORT num_columns;                    /* number of columns in column_name */

     CHAR  **column_name;                  /* array of column names */

     CHAR  index_name[SE_MAX_COLUMN_LEN];  /* the index name */

     BOOL  unique;                         /* unique index */

     BOOL  *ascending;                      /* ascending order */

} SE_INDEX_DEF;

Returns

SE_SUCCESS
SE_DB_IO_ERROR

SE_INVALID_CONNECTION

SE_INVALID_COLUMN_DEF

SE_NET_FAILURE

SE_NO_PERMISSIONS

SE_SDE_NOT_STARTED

SE_TABLE_NOEXIST