db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r1422062 - /db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita
Date Fri, 14 Dec 2012 19:57:50 GMT
Author: chaase3
Date: Fri Dec 14 19:57:48 2012
New Revision: 1422062

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

Merged patch DERBY-6010.diff to 10.9 doc branch from trunk revision 1419490.

Modified:
    db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita

Modified: db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita?rev=1422062&r1=1422061&r2=1422062&view=diff
==============================================================================
--- db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita (original)
+++ db/derby/docs/branches/10.9/src/ref/rrefsqlj81859.dita Fri Dec 14 19:57:48 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
+columns.</p></section>
 <section><title>Adding constraints</title><p>ALTER TABLE ADD CONSTRAINT
adds
 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



Mime
View raw message