Part III. Creating Database Objects
This third part describes how database objects are created. Database object is the generic term for, among other things, tables, keys, views, and indexes. These are the objects we have to create and that together form a database.
Chapter 15, “Creating Tables,” describes all the statements for creating and changing tables. We discuss in detail the properties of the different data types.
When tables are created, it is possible to specify integrity constraints. These constraints are explained separately in Chapter 16, “Specifying Integrity Constraints.” This chapter also reviews primary keys, alternate keys, foreign keys, and check integrity constraints, along with some other topics.
In Chapter 17, “Character Sets ...
Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
