O'Reilly logo

SQL for Microsoft Access, 2nd Edition by Neal A. Berkowitz, Cecelia L. Allison

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 11Table Management and Indexes

Introduction

In this chapter, you will learn how to modify a column in an existing table, delete a table, and improve data retrieval time using indexes.

Keywords

ADD

ALTER COLUMN

ALTER TABLE

CREATE INDEX

DEFAULT

DISALLOW NULL

DROP INDEX

IGNORE NULL

PRIMARY

UNIQUE

WITH

Definitions

ALTER TABLE — Used to modify table definitions in an existing table.

DISALLOW NULL — Used to prevent null data from being inserted into a column.

IGNORE NULL — Used to cause null data in a table to be ignored for an index.

INDEX — Sorts and saves the values of a column in a different location on the computer with a pointer to the presorted records.

PRIMARY — Used to designate a column as a primary key.

UNIQUE — Used to ensure ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required