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
EXISTS
FIRST ()
FLOAT
FOREIGN KEY
FORMAT (ColumnName, DateFormat)
GROUP BY
HAVING
HOUR ()
IGNORE NULL
IMAGE
IN
INDEX
INNER JOIN
INSERT INTO
INSERT INTO SELECT
INSTR (Start, SourceString, SearchString)
INT ()
INTEGER
INTO
IS NOT NULL
IS NULL
LAST ()
LCASE ()
LEFT (StringExpression, n)
LEFT JOIN
LEN ()
LIKE
LTRIM ()
MAX ()
MID (StringExpression, Start, Length)
MIN ()
MINUTE ()
MONEY
MONTH ()
NCHAR
NOT
NOT EXISTS
NOT NULL
NOW ()
NTEXT
NULL
NUMBER
NUMERIC
Nz (Variant [, ValueIfNull])
ON
ON DELETE CASCADE
ON UPDATE CASCADE
OR
ORDER BY
OUTER JOIN
PRIMARY KEY
REAL
RIGHT (StringExpression, n)
RIGHT JOIN
ROUND (Fieldname, DecimalValue)
RTRIM ()
SECOND ()
SELECT
SELECT INTO
SET
SMALLINT
SOME
SPACE ()
STDEV ()
STDEVP ()
SUM ()
TABLE
TIME ()
TIMESERIAL (hour, minute, second)
TINYINT
TOP
TOP PERCENT
TRANSFORM
TRIM ()
TRUNCATE (Fieldname, DigitValue)
UCASE ()
UNION
UNION ALL
UNIQUE
UNIQUEIDENTIFIER
UPDATE
VAR ()
VARCHAR
VARP ()
VIEW
WEEKDAY ()
WHERE
WITH
YEAR ()