Alter the schema of a database table

Available with Standard or Advanced license.

You can use ArcGIS to add a field to, drop a field from, or rename fields in tables that you own in the database.

To do this, connect to the database as the owner of the table and open it in fields view.

Add, rename, or delete fields

To create, rename, or delete fields in ArcGIS Pro, you can use fields view.

  1. Connect to the database that contains the table you want to alter.

    Be sure to connect as the table owner.

  2. In the Catalog pane, right-click the table and point to Design and to Fields.

    This opens the fields view.

  3. Alter the schema by doing one of the following:
    • If you want to delete a field, choose the field row and press Delete.

      All data stored in this field is removed when you delete the field.

    • If you want to add a field, click New Field on the ribbon, which adds a new column to the table. Provide a field name and data type.
    • If you want to rename a field, click the existing text in the Field Name column and type a new name.

    Field names should not contain spaces or nonalphanumeric characters. See Database data and ArcGIS for information on field name length.

  4. Click Save on the fields ribbon to commit your schema changes.