SQL Fundamentals, Third Edition

Chapter 6. Creating Your Own Tables

In this chapter, you learn how to create your own tables in a way that provides maximum control over every aspect of the tables. In chapter 4, you created new tables from other tables. Here, you create tables from the beginning, without relying on other tables.

Creating Tables		211
6-1	The create table command	211
6-2	Datatypes in Oracle and Access	212
6-3	Text datatypes	217
6-4	Numeric datatypes	222
6-5	Date/time datatypes	222
6-6	Other datatypes	222
6-7	Putting data into a new table	223
6-8	Creating the l_employees table in Oracle	224
Changing Tables		226
6-9	Adding a primary key to a table	226
6-10	Changing the primary key of a table	228
6-11	Adding a new column to a table	229
6-12	Expanding the length of a column	231
6-13	Deleting a column from a ...