You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2005/05/11 20:18:29 UTC

svn commit: r169669 - /incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita

Author: jta
Date: Wed May 11 11:18:28 2005
New Revision: 169669

URL: http://svn.apache.org/viewcvs?rev=169669&view=rev
Log:
Committed Jeff Levitt's patch for DERBY-168

Modified:
    incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita

Modified: incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita?rev=169669&r1=169668&r2=169669&view=diff
==============================================================================
--- incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita (original)
+++ incubator/derby/docs/trunk/src/ref/rrefsqlj81859.dita Wed May 11 11:18:28 2005
@@ -32,7 +32,6 @@
 <li>add a constraint to a table</li>
 <li>drop an existing constraint from a table</li>
 <li>increase the width of a VARCHAR, CHAR VARYING, and CHARACTER VARYING column</li>
-<li>add a default value for an existing column in a table</li>
 <li>override row-level locking for the table (or drop the override)</li>
 </ul></p></section>
 <section><title>Syntax</title> <codeblock><b>ALTER TABLE <i><xref href="rreftablename.dita#rreftablename"></xref></i>
@@ -100,13 +99,10 @@
 42837).</li>
 </ul></p></section>
 <section><title>Messages</title> <p><indexterm>Defaults<indexterm>setting</indexterm></indexterm>You
-can specify a default value for a new column or add a default value to an
-existing column. A default value is the value that is inserted into a column
+can specify a default value for a new column. A default value is the value that is inserted into a column
 if no other value is specified. If not explicitly specified, the default value
 of a column is NULL. If you add a default to a new column, existing rows in
-the table gain the default value in the new column. If you add a default to
-an existing column, existing rows in the table do not gain the default value
-in the new column.</p> <p>You can set the interval between consecutive values
+the table gain the default value in the new column.</p> <p>You can set the interval between consecutive values
 of the identity column to an existing column in a table. If there are existing
 rows in the table, the values in the column for which the SET INCREMENT default
 was added do not change. Note that this means that values in the column are