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

Previous Topic: COPY Function—Copy Data Rows

Next Topic: DROPCOLS Function—Remove Table Columns

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. The following is the syntax for the DELETE function:

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