[DERBY-4016] Document syntax change for ALTER TABLE in Reference Manual

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.1.1
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Camilla Haase
• Created: 12/Jan/09 16:38
• Updated: 02/May/13 02:29
• Resolved: 21/Jan/09 19:49

Description

DERBY-4013 adds support for the standard SET keyword in addition to the optional WITH keyword in ALTER TABLE ALTER [COLUMN] statements. This change should be documented in the Reference Manual.

Question: [WITH] DEFAULT occurs also in ALTER TABLE ADD COLUMN. Will SET work here as well?

Issue Links

• depends upon: DERBY-4013 Allow standard SQL syntax: ALTER TABLE ALTER [COLUMN] <col> SET DEFAULT <default>