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

Previous Topic: DELETE Function—Remove Table

Next Topic: FREE Function—Remove the Global Variable Enqueue

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 each column name is separated by a blank.

The DROPCOLS function 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 will be 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.