Chapter 12. Create, Alter, and Drop Tables

Chapter Objectives

In this chapter, you will learn about:

• Creating and Dropping Tables

• Altering Tables and Manipulating Constraints

This chapter introduces you to the Data Definition Language (DDL) commands associated with tables, the type of database object most frequently used. Table 12.1 provides an overview of other commonly used object types discussed in this and the following chapters.

Table 12.1 Commonly Used Database Object Types

image

image

The DDL commands allow you to create, modify, and remove database ...

Get Oracle SQL By Example 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.

Start your free trial