X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Ftable.lisp;h=1b28c4ff10db3b6b37bf181ee09b702576978b3e;hb=00db38f0f374ef2b9440979db71997801cceb4e0;hp=3820c19bd61d623a02ee50aeae155fe605c15789;hpb=270e7b5d19d51c1a19d30b54996d89576c63d358;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*))