[DERBY-6010] Reference Manual should clarify what ALTER TABLE ADD COLUMN does

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.9.1.0, 10.10.1.1
• Fix Version/s: 10.9.2.2, 10.10.1.1
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Camilla Haase
• Created: 07/Dec/12 22:56
• Updated: 24/Jan/13 18:00
• Resolved: 14/Dec/12 20:04

Description

The documentation should state explicitly that ALTER TABLE ADD COLUMN adds the new column at the end of the table row. If you need to change a column (for example, 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.