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:
You can add, but do not delete or modify columns on
existing 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.