DROP_COLUMNS

Messages with __TYPE=6 (XlaConstants.DROP_COLUMNS) indicate that a table has been altered by dropping existing columns.

Table 6-8 shows the name/value pairs that are in a MapMessage instance generated for a DROP_COLUMNS operation.

Table 6-8 DROP_COLUMNS Data Provided in Update Message

Name	Value
OWNER	String value of the owner of the altered table
NAME	String value of the name of the altered table
COLUMNS	String value containing the names of the columns dropped from the table Format: <col1name>[;<col2name> [;<col3name>[;...]]] Note: For each dropped column, additional name/value pairs that describe the column are in the MapMessage.
_column_name_TYPE	Integer value representing the data type of this column (from java.sql.Types)
_column_name_PRECISION	Integer value containing the precision of this column (for NUMERIC or DECIMAL)
_column_name_SCALE	Integer value containing the scale of this column (for NUMERIC or DECIMAL)
_column_name_SIZE	Integer value indicating the maximum size of this column (for CHAR, VARCHAR, BINARY, or VARBINARY)
_column_name_NULLABLE	Boolean value indicating whether this column can have a NULL value
_column_name_OUTOFLINE	Boolean value indicating whether this column is stored in the inline or out-of-line part of the tuple
_column_name_INPRIMARYKEY	Boolean value indicating whether this column is part of the primary key of the table