SE_table_drop_column

Deletes a column from a DBMS table

Usage syntax

LONG SE_table_drop_column
(SE_CONNECTION connection,
const CHAR *table,
const CHAR *column);

Parameters
connection The connection handle
table The name of the table
column The DBMS column name
Description

SE_table_drop_column deletes a column from a DBMS table. You cannot delete spatial columns with this function. Use SE_layer_delete to remove a spatial column.

Note: Dropping columns is only allowed in DB2 for Linux/Unix/Windows (LUW) DBMSs beginning with DB2 version 9. Each time a column is dropped from a table in DB2 LUW 9, a REORG and RUNSTATS operation is performed on the table to bring the DB2 data pages up to date. These operations take place after each and every column drop. Be aware that if the table is extremely large, the REORG operation could take a significant amount of time and database resources to complete. Columns cannot be dropped from geodatabases in DB2 for z/OS.

Returns

SE_SUCCESS
SE_DB_IO_ERROR

SE_INVALID_CONNECTION

SE_INVALID_COLUMN_DEF

SE_INVALID_POINTER

SE_NET_FAILURE

SE_SDE_NOT_STARTED

SE_TABLE_NOEXIST