Columns in a Database Table

In a table, data is arranged into columns. Each column stores one data element, such as a first name, one line of an address, a price, or any similar discrete unit of information.

When columns are created in a table, they are given a name that identifies their purpose, such as FirstName or Address1. In most databases, you must also specify additional properties, such as how long the longest entry in the column will be, and what type of data the column will contain - characters, integers, floating-point numbers, dates or times, and so on. Other column properties can include whether the column is the table's primary key, whether users must enter a value into it, and what its default value is.

You can edit the column properties for tables directly in the database diagram. For details about which properties are available in your database, see your database documentation.

To See
Add new column definitions to the end of a table Inserting Columns into a Table
Copy the column definitions from one table to another table in the same diagram or in different diagrams Copying Columns from One Table to Another
Move the column definitions from one table to another table in the same database diagram or in a different diagram Moving Columns from One Table to Another
Delete columns from a table and from the database Deleting Columns from a Table
Set or edit the column definition (properties) for a database table Column Properties