SQL Reserved Words

The following table contains a list of SQL reserved words that Relativity prevents you from using as a column name or table name when creating a new table. This is necessary because some ODBC-enabled applications can not handle these words as column or table names.

ADD

ALL

ALTER A

AND

ANY

AS

ASC

AVG

BETWEEN

BY

CASCADE

CHECK

COUNT

CREATE

CROSS

DEFAULT

DELETE

DESC

DISTINCT

DROP

EXISTS

FOREIGN

FROM

FULL

GRANT

GROUP

HAVING

IF

IN

INDEX

INNER

INSERT

INTO

IS

JOIN

KEY

LEFT

LIKE

MAX

MIN

NOT

NULL

ON

OR

ORDER

OUTER

PRIMARY

PUBLIC

REFERENCES

RESTRICT

REVOKE

SELECT

SET

SUM

SVBEGIN

SVEND

TABLE

TO

UNION

UNIQUE

UPDATE

USER

VALUES

VIEW

WHERE