DEFAULT Clause with ALTER TABLE

The ALTER TABLE SQL command alters the schema of an existing table by adding new columns or modifying existing columns of the specified table. c-treeACE SQL now has support for specifying a default value when adding or modifying a column. With the ADD and MODIFY column operations an optional DEFAULT value can be specified for each of the columns.