Product Documentation

V9 Update Guide

Previous Topic

Next Topic

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. FairCom DB 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.

TOCIndex