ALTER TABLE

Derby uses a slightly different ALTER TABLE syntax for altering column defaults. While SQL99 uses DROP and SET, Derby uses DEFAULT.

Related concepts
Dynamic SQL
Cursors
Information schema
Transactions
Stored routines and PSM
Calling functions and procedures
Unique constraints and nulls
NOT NULL characteristic
DECIMAL max precision
CLOB and BLOB
Expressions on LONGs