Database Reference
In-Depth Information
In this chapter, you learned several new SQL statements.
CREATE TABLE
is used to create new tables,
ALTER TABLE
is used to change table columns
(or other objects like constraints or indexes), and
DROP TABLE
is used to
completely delete a table. These statements should be used with extreme cau-
tion, and only after backups have been made. You also learned about database
engines, defining primary and foreign keys, and other important table and col-
umn options.
