Relational Data Framework Reference › Relational Table Editor Batch API Functions › DROPCOLS Function—Remove Table Columns

DROPCOLS Function—Remove Table Columns

The DROPCOLS function removes unwanted columns from a table. The table is then placed into storage, deleted, and recreated without the dropped columns. The list of column names to remove is limited to 200 bytes in length, and a blank separates each column name.

DROPCOLS has the following syntax:

OI ASOTEAPI DROPCOLS TABLE(table_name) COLUMNS(colname colname…) SSMPROT(YES|NO)

The SSMPROT keyword determines whether the potentially destructive operation is performed on an active System State Manager resource table or the SSM directory table. A value of NO unconditionally allows the operation. A value of YES prohibits the requested operation against any active SSM table. The default is NO except for the DELETE, DROPCOLS, and RENAME operations.