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