Renaming Fields

  • Article

You can rename existing table fields in two ways.

To rename a table field

  • In the Table Designer, enter a new field name in the Name box for the existing field.

    -or-

  • Use the RENAME COLUMN clause of the ALTER TABLE command.

For example, to rename the column company in the customer table, you could issue the following command:

ALTER TABLE customer RENAME COLUMN company TO company_long_new_name

In the previous example, the new field name takes advantage of the ability to create long field names in database tables.

See Also

Deleting Fields | Setting or Changing Field-Level or Table Rules | Working with Tables | Setting or Changing Default Values | Modifying the Table Structure