3. Using the Tables Utility : How You Add or Delete Columns in an Existing Table
 
Share this page                  
How You Add or Delete Columns in an Existing Table
To add or delete columns in an existing table, you must use query language statements outside of the Tables Utility. This allows you to recreate the table with all or some of the columns from the original table, as well as add any new columns. For specific instructions on how to do this, see the Database Administrator Guide for the system on which your database resides.
Note:  When you recreate a table, you also must recreate any synonyms, views, or indexes based on the original table. In addition, you must edit any forms or reports based on the original table, if the form or report references any changed or deleted columns or if it is to access any new column in the table.