Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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