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.
- 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:
You cannot 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:
- Connect to the geodatabase or database.
- Right-click the table or feature class and click Rename.
The name is highlighted.
- Type a new name.
Names must start with a letter and cannot exceed the maximum number of characters the DBMS allows for the table names.
- Press the Enter key.