X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Ftable.lisp;h=1b28c4ff10db3b6b37bf181ee09b702576978b3e;hb=5be31565b7d87b90f0e79a9e61af84ad05e12920;hp=3820c19bd61d623a02ee50aeae155fe605c15789;hpb=8a8ee2d7d791b7a3efaed06420802a925d16fca3;p=clsql.git

diff --git a/sql/table.lisp b/sql/table.lisp
index 3820c19..1b28c4f 100644
--- a/sql/table.lisp
+++ b/sql/table.lisp
@@ -61,7 +61,10 @@ if IF-DOES-NOT-EXIST is :error."
          (return-from drop-table nil)))
       (:error
        t))
-    (let ((expr (concatenate 'string "DROP TABLE " table-name)))
+    (let ((expr (concatenate 'string "DROP TABLE " table-name
+			     (if (eq :oracle (database-type database))
+				 " PURGE"
+			       ""))))
       (execute-command expr :database database))))
 
 (defun list-tables (&key (owner nil) (database *default-database*))