Managing Tables

Previous

Next

Tables are the basic unit of data storage in an Oracle database. They hold all user-accessible data. A table is a two-dimensional object made up of columns and rows. For example, the employees table includes (vertical) columns called employee_id, first_name, and last_name. Each (horizontal) row in the table contains a value for employee name and ID number. The most common type of table in an Oracle database is a relational table.

This section contains the following topics:

• Ensuring Data Integrity in Tables With Constraints

• Creating a Table

• Adding a Column To a Table

• Modifying a Column In a Table

• Dropping a Column From a Table

• Adding a Check Constraint

• Adding a Unique Constraint

• Adding a Primary Key Constraint

• Adding a Foreign Key Constraint

• Viewing Existing Constraints

• Disabling and Enabling a Constraint

• Dropping a Constraint

• Adding Data to a Table

• Modifying Data in a Table

• Removing a Row in a Table

• Dropping a Table