Maintaining Columns on SQL Tables

Use the SQL Columns form to add, delete, or modify columns on tables. However, you cannot make changes to certain restricted tables.

See Restricted Tables.

Caution:  Do not delete or modify columns on base application tables. Doing so can cause system instability.

To add a new column to a table that already contains columns, the new column must meet at least one of these conditions:

  • Allows nulls
  • Has a default definition specified
  • Is an identity or timestamp data type

If none of these conditions is true, then the column can be added only to an empty table.

You can also change the definition of an existing column, for example, the data type.

Related topics
Maintaining Tables and Other SQL Schema Elements