db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1419490 - /db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
Date Mon, 10 Dec 2012 14:30:46 GMT
Author: chaase3
Date: Mon Dec 10 14:30:44 2012
New Revision: 1419490

URL: http://svn.apache.org/viewvc?rev=1419490&view=rev
DERBY-6010  Reference Manual should clarify what ALTER TABLE ADD COLUMN does 

Modified a Reference Manual topic.

Patch: DERBY-6010.diff


Modified: db/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=1419490&r1=1419489&r2=1419490&view=diff
--- db/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj81859.dita Mon Dec 10 14:30:44 2012
@@ -125,7 +125,12 @@ trigger is defined, and all references t
 so that they pick up the new column.</note>
 <p>If you add a generated column to a table, 
 <ph conref="../conrefs.dita#prod/productshortname"></ph> computes the generated
-values for all existing rows in the table.</p></section>
+values for all existing rows in the table.</p>
+<p>ALTER TABLE ADD COLUMN adds the new column at the end of the table row. If
+you need to change a column in a way not permitted by ALTER TABLE ALTER
+COLUMN (for example, if you need to change its data type), the only way to do so
+is to drop the column and add a new one, and this changes the ordering of the
 <section><title>Adding constraints</title><p>ALTER TABLE ADD CONSTRAINT
 a table-level constraint to an existing table. Any supported table-level constraint
 type can be added via ALTER TABLE. The following limitations exist on adding

View raw message