Product Documentation

SQL Operations Guide

Previous Topic

Next Topic



Affects SQL DROP TABLE command operation. This option retains files on disk when tables are dropped from the SQL dictionary. Use this option when you want to undo a DROP TABLE command. You can also use this option when you want files/tables to remain available in Low‑Level, ISAM, and c-treeDB API APIs, as well as c-treeRTG, and not in SQL.

This option is particularly useful when using c‑tree features, such as ctutil -sqllink, ctutil -sqlize, ctdbaddtable, and ctsqlimp utilities and the ctsqlimport API, which may bring extra files into the SQL data dictionaries that later need to be dropped from SQL without removing them from disk.