-- MAGIC - CSV table do not support Delete Operation, and we may have to use truncate in that case. -- MAGIC - in general truncate will delete complete table data, however we can specify constraint ...

When you Export database to a sql, it doesn't matter which options you choose, either Drop table/Create table or just Create table, and then select Delete + Insert (truncate existing data), the ...