Database Reference
In-Depth Information
Figure 11-13.
Abridged Version of the Alter-Table Statement
Example 6:
We could add an additional attribute for course-abbreviation to the
Course
table:
Example 7:
The following statement appends an additional attribute (and foreign
key) to the
Student
table.
Oracle also allows you to rename a table (or any valid database object) via the
Rename
command. You can also remove all rows from a table via the
Truncate-Table
command. The abridged syntax for each command is as follows: