Inserting Columns into a Table

You can add new column definitions to a table to capture additional data that isn’t already stored in an existing column. The Column Properties view, which shows a table with all of its currently defined columns, provides blank grid rows so that you can easily add new column definitions to your database table.

To insert columns into a table

1. In your database diagram, select the table that you want to add new columns to.
   
   
2. If the table is not already in Column Properties view, right-click the table and choose Column Properties from the shortcut menu.
   
   
3. Right-click a row in the table and select Insert Column from the shortcut menu. A blank column row is inserted.

   -or-

   Place the cursor in the first blank cell in the Column Name column.

4. In the Column Name column, type the column name in the cell. The Column Name is a required value.
   
   
5. Press the TAB key to go to the Datatype cell. This is a required value.

The default values for your database are added when you create a new column. Define other properties for the column as needed. You can change any of these values and set additional properties at any time according to the rules of your database. For more information about the column properties available to you, refer to your database documentation.