SE_table_drop_column |
Deletes a column from a DBMS table
LONG SE_table_drop_column
(SE_CONNECTION connection,
const CHAR *table,
const CHAR *column);
connection | The connection handle |
table | The name of the table |
column | The DBMS column name |
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.
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