Define a column

Define a column by using the New Table Definitions wizard. A column defines a unit of information within a table row. Each row is an entry in the table. Each column is a category of information that applies to all rows.

When you add a table to a database, you can define the columns that compose it. Columns determine the kind of data that the table can hold.

To define a column:

1. On the Table Columns page of the New Table Definition wizard, click Add another.

2. Set the properties for the column. The available properties depend on the type of column and the database vendor type.

3. You can add columns to the primary key when you define the column on the Columns page by selecting the Key column check box.

4. Finish the definition of the table on the other pages, and click Finish. Your table is added to the database, and its columns are defined.

You can edit the column information, add columns, or delete columns afterwards by using the table editor. To open the table editor, double-click on the table in the Data Definition view.

You can also delete a column in the Data Definition view by right-clicking on the column and then clicking Delete.

 

Parent topic

Defining a table