SQL Extensions   «Prev  Next»

Lesson 9

Table Constraints Conclusion

You have now completed a whirlwind tour of how to create tables and constraints.
In this module, you practiced creating a table with several columns and saw how to set the space parameters for a table and watched what happens when a table outgrows its initial allocation of space. You observed what happens when you drop a table. You also saw how to disable a constraint and when you need to do that.
In this module, you learned how to:
  1. Identify the components of the CREATE TABLE command
  2. Describe how tables, tablespaces, and datafiles fit together
  3. Identify the parameters that define storage space
  4. Describe the advantages of using PRIMARY KEY constraints
  5. Identify the syntax components of the FOREIGN KEY, CHECK, and UNIQUE constraints
  6. Change columns in an existing table
  7. Describe the effects of dropping a table and disabling or removing a constraint


In this module you were introduced to the following new glossary terms:
  1. Datafile: The physical files that Oracle uses to store data. A datafile is a contiguous segment of a disk drive.
  2. Block: Each tablespace is subdivided into increments called blocks. The exact size for a block depends on the operating system in which the database resides. One block is the smallest increment of space the database can allocate to a table.
  3. Primary key: One or more columns that define a unique row in a table. A table can contain only one primary key.
  4. Unique key: A second primary key in a table. A table can contain more than one unique key.
  5. Constraint: A constraint is a database rule that you define within the database to enforce certain conditions regarding the data that is stored in the database tables.
  6. Column constraint: Constraints that apply to one column.
  7. Table constraint: Constraints that apply to more than one column.
  8. Foreign key: A column or list of columns in one table that contain data that references the primary key of another table.
  9. Check constraint: A condition that is required for every row in the table.

In the next module you will use SQL to insert, update, and delete data within the Oracle database.

Removing TableConstraints - Quiz

Click the Quiz link below to answer a few questions about removing tables and constraints.

Removing TableConstraints - Quiz

Oracle Database SQL