Chapter 20. Creating Tables
This chapter describes the statements for creating, updating, and deleting tables. We take the view that the user knows what data must be stored and what the structure of the data is—that is, what tables are to be created and what the appropriate columns are. In other words, the user has a ready-to-use database design at his or her disposal.
20.2 Creating New Tables
You can use the
CREATE TABLE statement to construct new tables to store rows of data. The definition of this statement is complex and extensive. For that reason, we explain the statement’s features step by step and build up the definition slowly. The following sections and chapters explain the concepts of column definition, table integrity ...