Previous Topic: Add a New Table

Next Topic: Save Changes


Add a New Column

Use the Schema Designer to add a column.

To add a column to a table

  1. Select the table for which you want to add a column (or select any of its existing columns).
  2. Select Add Column from the Edit menu, or click the Add Column button.

    The Add New Column dialog appears.

  3. Enter the column name in the New Column Name field and click OK. The names of a site-defined column added to a standard table must begin with the letter z to prevent conflict with possible future standard columns.

    WSP verifies that you added the prefix, but adds a z to the beginning of the column name if necessary.

  4. Complete the fields in the Column Info tab as appropriate.