How to add columns to a table

Previous Next

You can add a column to a table by using a wizard or by filling out a form.

Adding a column by using a wizard

1.Right-click the table name in the Project Catalog, and choose Add Column.
The New Column wizard appears.
2.Enter attribute values for your new column in each of the wizard's dialogs as requested.

Adding a column by filling out a form

1.Choose Define, Tables, Database Tables from the USoft Definer main menu.
2.Query the table where you want to add a column.
3.In the Columns tab, on the first empty line in the spreadsheet, enter attribute values for your the new Column. Save work.

 

Once the column has been created, you can refine both the table and its columns if required, by double-clicking on the table name in the Project catalog and editing. You can use the What's This? help in the Tables window for help on each field.

 

See also

Columns