From 794541ef3899a614f1d3ecdcd20204073ab9ae03 Mon Sep 17 00:00:00 2001
From: Constantin Michael <constantin@codesynthesis.com>
Date: Thu, 20 Oct 2011 10:28:59 +0200
Subject: Cascade constraints when dropping Oracle tables

---
 odb/relational/oracle/schema.cxx | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'odb/relational')

diff --git a/odb/relational/oracle/schema.cxx b/odb/relational/oracle/schema.cxx
index ff218cc..8115f2f 100644
--- a/odb/relational/oracle/schema.cxx
+++ b/odb/relational/oracle/schema.cxx
@@ -68,7 +68,7 @@ namespace relational
           os << "BEGIN" << endl
              << "  BEGIN" << endl
              << "    EXECUTE IMMEDIATE 'DROP TABLE " << quote_id (table) <<
-            "';" << endl
+            " CASCADE CONSTRAINTS';" << endl
              << "  EXCEPTION" << endl
              << "    WHEN OTHERS THEN" << endl
              << "      IF SQLCODE != -942 THEN RAISE; END IF;" << endl
-- 
cgit v1.1