Skip to main content
Previous sectionNext section


Specify whether DROP TABLE deletes the table’s data in addition to the table.


[SQL]    DropDelete=n

n is either 1 or 0. The default value is 1.


When DropDelete is enabled (n = 1), a DROP TABLE statement deletes the table and the table's data. When this parameter is not enabled, a DROP TABLE statement deletes the table, but does not delete the data.

For further details, refer to the DROP TABLE command.

Changing This Parameter

To set the desired value for DropDelete from the Terminal, use the SetOption(“DDLDropTabDelData”)Opens in a new window method of the %SYSTEM.SQL.UtilOpens in a new window class. See the class reference for details.

You can also change DropDelete with the Config.SQLOpens in a new window class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).

FeedbackOpens in a new window