Database Reference
In-Depth Information
Figure 3-10.
Looking at the re-created table and column list
You may want to compare Figures 3-9 and 3-10 to understand the difference, which is achieved by
using
ALTER
and
CREATE
, respectively.
Summary
This chapter described how to create database and tables. You also learned about techniques to add a
column to an already created table through the
ALTER
statement, which basically modifies a precreated
table. You also learned to use the
DROP
statement, which removes a table object from the database.
In the next chapter, you'll start working with data manipulation concepts.
