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, CreatedBy, etc., are automatically added.
When a column name is changed or inserted, the Insert and UpdatePenultimate triggers are regenerated for that table.
To add a new column to a table that already contains columns, the new column must meet at least one of these conditions:
If none of these conditions is true, then the column can be added only to an empty table.
Maintaining Tables and Other SQL Schema Elements