Chapter 7. Formats, Sequences, and Indexes
You now know how to build your own tables and put data in them. This chapter discusses some other features you may want to add to your tables.
Formats affect the appearance of the data without changing its value. In Access, formats can be part of the definition of a table. In Oracle, they are used mostly within SQL statements to format dates.
Sequences provide a way to automatically number the rows of a table.
Indexes are used mostly to speed up the processing of
select statements within large databases.
This chapter also discusses the Data Dictionary, which shows you how to find information about the tables you create.