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 table properties (for nonspatial tables) or feature class properties (for spatial tables).
- Start ArcCatalog or ArcMap and open the Catalog window.
- Connect to the database that contains the table you want to alter.
Be sure to connect as the table owner.
- Right-click the table and click Properties.
- Click the Fields tab.
- Alter the schema by doing one of the following:
- If you want to delete a field, choose it from the list of fields and press Delete. All data stored in this field is lost when you delete the field.
- If you want to add a field, type a name for the field in the next available line under Field Name, click in the corresponding Data Type field to choose what type of data you want the field to store, and alter Field Properties as necessary.
- If you want to rename a field, click on the existing text in the Field Name column and type a new name.
Field names cannot contain spaces or nonalphanumeric characters. Field names cannot exceed 31 bytes in most databases (30 bytes in Oracle and IBM DB2 databases).
- Click OK to close the Properties dialog box.