SQL for Microsoft Access, 2nd Edition

Appendix B Frequently Used SQL Keywords in Microsoft Access

This appendix lists the most frequently used keywords in Access SQL. Most of the following keywords are used throughout the chapters. Some of the keywords are only available in version SQL-92 and later, while others are available in all versions of SQL. Keep in mind that there is a wide range of keywords in the SQL language and new keywords are continually being added.

ABS ()

ADD

ALL

ALTER COLUMN

ALTER TABLE

AND

ANY

AS

ASC

AVG ()

BETWEEN

BINARY

BIT

CCUR

CHAR

COLUMN

CONSTRAINT

COUNT (*)

COUNT (ColumnName)

COUNTER

CREATE INDEX

CREATE TABLE

CREATE VIEW

DATE ()

DATEPART (interval, date [firstweekday] [, firstweek])

DATETIME

DAY ()

DECIMAL

DEFAULT

DELETE

DELETE TABLE

DESC

DISALLOW NULL

DISTINCT

DISTINCTROW

DROP INDEX

DROP VIEW ...