Previous Topic: COPY Function—Copy Data RowsNext Topic: DROPCOLS Function—Remove Table Columns

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

DELETE Function—Remove Table

The DELETE function removes all the rows from a table and drops the table from the Relational Data Framework so that it no longer exists.

DELETE has the following syntax:

OI ASOTEAPI DELETE TABLE(table_name) 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.