SQL Columns

Use this form, along with the SQL Tables form and SQL Tables Constraint form, to create, modify, or delete SQL database tables, or to add columns to existing tables. For new tables, the required system columns such as CreateDate and CreatedBy are automatically added.

Note: System administrators can use the Metadata Access Controls form to restrict access to core SQL tables. You cannot modify SQL tables that are set to Locked in the Metadata Access Controls form. You can view SQL tables that are set to Read Only but you cannot modify them. You can view and modify SQL tables that are set to Unlocked.

When a column name is changed or inserted, the Insert and UpdatePenultimate triggers are regenerated for that table.

Caution: 
You can add to, but do not delete or modify existing base application tables or columns. Doing so can cause system instability.
Related topics