Lesson 1
Creating Modifying Table Structures (DDL)
This module introduces the SQL commands necessary to create and modify database tables, indexes, and
constraints[1].
Here again, Oracle has taken the basic SQL commands and extended them to include parameters specifically tailored for the Oracle database system.
Module objectives
By the end of this module, you will know how to:
- Identify the components of the
CREATE TABLE
command
- Describe how tables, tablespaces, and datafiles fit together
- Identify the parameters that define storage space
- Describe the advantages of using primary key constraints
- Identify the syntax components of the foreign key, check, and unique constraints
- Change columns in an existing table
- Describe the effects of dropping a table and disabling or removing a constraint
TABLE Commands
First, you will work with the CREATE TABLE
command. There are several lessons on this because there is a vast amount of information you need to know about this feature, including not only the columns to be included in the table, but also the amount of physical space to allocate the table, some validation, and even the relationships between the table and other tables.
Next, you will find out how to modify the table's construction once the table has already been created, using the
ALTER TABLE
command. Finally, you will discover how to remove a table from the database and either remove or disable a relationship that was defined earlier.
The next lesson starts you out on the basics of the CREATE TABLE
command.
[1]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.