[ http://issues.apache.org/jira/browse/DERBY-126?page=comments#action_12313760 ]
Jeff Levitt commented on DERBY-126: ----------------------------------- I think I fixed this before I contributed the DITA converted docs. See the current docs: http://incubator.apache.org/derby/docs/ref/rrefsqlj81859.html There is no section marked "Modifying columns," and the sentence: "You can specify a default value for a new column or add a default value to an existing column (see Modifying Columns)." now says: "You can specify a default value for a new column." Can this issue be closed? > Documentation bug. Doc says column default can be edited - it looks like it > cannot > ---------------------------------------------------------------------------------- > > Key: DERBY-126 > URL: http://issues.apache.org/jira/browse/DERBY-126 > Project: Derby > Type: Bug > Components: Documentation > Reporter: Bernd Ruehlicke > Priority: Minor > > From the e-mail trail on the Derby Mailing list > I think that part of the documentation needs to be changed... Unless someone > actually shows Derby can support modifying default values or add a default to > an existing column, either myself or you :-) should file a JIRA > documentation bug to fix the documentation. > Under the modifying columns, the document says two options are > available....1) Increase a VARCHAR length 2) specify an interval between > identity columns. > Satheesh > Bernd Ruehlicke wrote: > Thanx - the intresting bit here is that the documentation under "Setting > defaults" on > http://incubator.apache.org/derby/manuals/reference/sqlj26.html#HDRSII-S > QLJ-21322 sais > > "You can specify a default value for a new column or add a default value > to an existing column (see Modifying Columns)." > > > i.e. "... or add a default value to an existing column" > > > That's what I am looking for. > > B-) > > > -----Original Message----- > From: Satheesh Bandaram [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 18, 2005 1:32 PM > To: Derby Discussion > Subject: Re: Add a default to an existing column ? > > I am not aware of a way to modify a default value in Derby. > You can add a default at the table creation time, but not > sure if you can add a default to an existing column. > > Satheesh > > Bernd Ruehlicke wrote: > > Hmm - scary silence followed this e-mail. > > To clarify the mail. > > I want to be able to modify a default value for a > column. > > > Anybody know what is supported in Derby and what isn't ? > > B-) > > > > -----Original Message----- > From: Bernd Ruehlicke [mailto:[EMAIL PROTECTED] > Sent: Monday, January 17, 2005 1:12 PM > To: Derby Discussion > Subject: Add a default to an existing column ? > > Hmm - the documentation states that you can add > a default > value to an existing column in > > http://incubator.apache.org/derby/manuals/reference/sqlj26.htm > l#HDRSII-SQLJ-21322 but I cannot find any > syntax which works for me. > > Questions: > > 1) What is the syntax if I want to add a > default value to a column ? > > 2) What is the syntax if I want to modify a > default value of > a colum ? (Is this possible at all ?) > > Thanx > B-) -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira
