|
|
|
SQL_OPTION DROP_TABLE_DICTIONARY_ONLY
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.
