Skip to main content
Previous sectionNext section

DropDelete

DROP TABLE behavior.

Synopsis

[SQL]    DropDelete=n

Description

The value n may be 1 or 0:

  • When 1 (true) a DROP TABLE statement deletes the table and the table's data.

  • When 0 (false) it deletes the table, but does not delete the data.

Examples

DropDelete=1

Range of Values

0 or 1. The default is 1.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, for the Does DDL DROP TABLE Delete the Table's Data setting, choose Yes (true) or No (false).