Rename a table

You can rename a table (nonspatial or spatial, also referred to as a feature class) in a database or geodatabase using ArcGIS Pro by right-clicking it, clicking Rename, typing a new name, and pressing Enter.

The following conditions apply:

• If the table is in a relational database or enterprise geodatabase, you must connect as the table owner to rename it.

• You cannot rename tables that are stored in cloud data warehouses or document databases.

• IBM Db2 does not allow tables to be renamed if the tables have a referential constraint defined on them.

• You cannot rename tables in SQLite if the database is configured to use SpatiaLite to store geometries.

• You cannot rename a table if someone else holds a lock on that table.

Note:

Do not use third-party software, such as an SQL client, to rename a table in a geodatabase, because it does not update the table name in the geodatabase system tables.

Follow the steps below to rename a table from ArcGIS Pro:

1. In the Catalog pane, connect to the geodatabase or database.

2. Right-click the table or feature class and click Rename.

   The name is highlighted.

3. Provide a new name.

   Names must start with a letter and cannot exceed the maximum number of characters the database or data warehouse allows for the table names.

4. Press the Enter key.