Tell Me
 

Modifying Tables

Previous previous|nextNext Page

You can modify tables using the SQL ALTER TABLE statement. You may need to change the table structure due to any of the following reasons:

  • You omitted a column.
  • Your column definition needs to be changed.
  • You need to remove columns.

The ALTER TABLE statement is used to:

  • Add a new column
  • Modify an existing column
  • Define a default value for the new column
  • Drop a column
  • Manage constraints

In Oracle SQL Developer, you can modify tables:

  • Using the Table Dialog
  • Using the SQL Worksheet