Return-Path: 
 <derby-commits-return-15606-apmail-db-derby-commits-archive=db.apache.org@db.apache.org>
X-Original-To: apmail-db-derby-commits-archive@www.apache.org
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 9442D9B02
	for <apmail-db-derby-commits-archive@www.apache.org>;
 Thu, 17 May 2012 13:29:58 +0000 (UTC)
Received: (qmail 47188 invoked by uid 500); 17 May 2012 13:29:58 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 47154 invoked by uid 500); 17 May 2012 13:29:58 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-commits-help@db.apache.org>
list-unsubscribe: <mailto:derby-commits-unsubscribe@db.apache.org>
List-Post: <mailto:derby-commits@db.apache.org>
Reply-To: "Derby Development" <derby-dev@db.apache.org>
List-Id: <derby-commits.db.apache.org>
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 47145 invoked by uid 99); 17 May 2012 13:29:58 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 13:29:58 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=5.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 May 2012 13:29:57 +0000
Received: from eris.apache.org (localhost [127.0.0.1])
	by eris.apache.org (Postfix) with ESMTP id 53CAC238897A;
	Thu, 17 May 2012 13:29:37 +0000 (UTC)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r1339595 -
 /db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
Date: Thu, 17 May 2012 13:29:37 -0000
To: derby-commits@db.apache.org
From: chaase3@apache.org
X-Mailer: svnmailer-1.0.8-patched
Message-Id: <20120517132937.53CAC238897A@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org

Author: chaase3
Date: Thu May 17 13:29:36 2012
New Revision: 1339595

URL: http://svn.apache.org/viewvc?rev=1339595&view=rev
Log:
DERBY-5591  Imprecise wording in documentation in ref man on DROP VIEW

Modified a Reference Manual topic.

Patch: DERBY-5591.diff

Modified:
    db/derby/docs/trunk/src/ref/rrefsqlj61102.dita

Modified: db/derby/docs/trunk/src/ref/rrefsqlj61102.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj61102.dita?rev=1339595&r1=1339594&r2=1339595&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj61102.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj61102.dita Thu May 17 13:29:36 2012
@@ -31,8 +31,15 @@ limitations under the License.
 <codeblock><b>DROP VIEW AnIdentifier</b></codeblock> </example>
 <section><title>Statement dependency system</title> <p>Any statements
 referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is
-disallowed if there are any views or open cursors dependent on the view. The
-view must be dropped before any objects that it is dependent on can be dropped.</p> </section>
+disallowed if there are any views or open cursors dependent on the view.</p>
+<p>Normally, you must drop a view before you drop any objects that the view
+depends on. However, if you issue an ALTER TABLE DROP COLUMN command with the
+CASCADE option, any views that depend on the column will be dropped. Also, if
+you use a REVOKE statement to revoke privileges on objects that a view depends
+on, the view will be dropped. Similarly, if you use a DROP ROLE statement to
+drop a role that has privileges on objects that a view depends on, the view will
+be dropped.</p>
+</section>
 </refbody>
 </reference>