Reserved keywords (Access custom web app)
Microsoft Access uses reserved keywords for defining, manipulating, and accessing databases. Reserved keywords are part of the grammar of the language that is used by Access to parse and understand SQL statements.
Important
Microsoft no longer recommends creating and using Access web apps in SharePoint. As an alternative, consider using Microsoft PowerApps to build no-code business solutions for the web and mobile devices.
Access reserved keywords
The following table lists Access reserved keywords.
| Keyword | Keyword | Keyword |
|---|---|---|
| ADD |
FILLFACTOR |
Quarter |
| ALL |
Float |
RAISERROR |
| ALTER |
FOR |
READ |
| AND |
FOREIGN |
READTEXT |
| ANY |
FREETEXT |
RECONFIGURE |
| AS |
FREETEXTTABLE |
REFERENCES |
| ASC |
FROM |
REPLICATION |
| AUTHORIZATION |
FULL |
RESTORE |
| BACKUP |
FUNCTION |
RESTRICT |
| BEGIN |
GOTO |
RETURN |
| BETWEEN |
GRANT |
REVERT |
| BREAK |
GROUP |
REVOKE |
| BROWSE |
HAVING |
RIGHT |
| BULK |
HOLDLOCK |
ROLLBACK |
| BY |
Hour |
ROWCOUNT |
| CASCADE |
IDENTITY |
ROWGUIDCOL |
| CASE |
IDENTITY_INSERT |
RULE |
| CHECK |
IDENTITYCOL |
SAVE |
| CHECKPOINT |
IF |
SCHEMA |
| CLOSE |
IN |
Second |
| CLUSTERED |
INDEX |
SECURITYAUDIT |
| COALESCE |
INNER |
SELECT |
| COLLATE |
INSERT |
SEMANTICKEYPHRASETABLE |
| COLUMN |
Integer |
SEMANTICSIMILARITYDETAILSTABLE |
| COMMIT |
INTERSECT |
SEMANTICSIMILARITYTABLE |
| COMPUTE |
INTO |
SESSION_USER |
| CONSTRAINT |
IS |
SET |
| CONTAINS |
ISO_Week |
SETUSER |
| CONTAINSTABLE |
JOIN |
ShortText |
| CONTINUE |
KEY |
SHUTDOWN |
| CONVERT |
KILL |
SOME |
| CREATE |
LEFT |
STATISTICS |
| CROSS |
LIKE |
SYSTEM_USER |
| Currency |
LINENO |
TABLE |
| CURRENT |
LOAD |
TABLESAMPLE |
| CURRENT_DATE |
LongText |
Text |
| CURRENT_TIME |
MERGE |
TEXTSIZE |
| CURRENT_TIMESTAMP |
Millisecond |
THEN |
| CURRENT_USER |
Minute |
Time |
| CURSOR |
Month |
TO |
| DATABASE |
NATIONAL |
TOP |
| Date |
No |
TRAN |
| DateWithTime |
NOCHECK |
TRANSACTION |
| Day |
NONCLUSTERED |
TRIGGER |
| DayofYear |
NOT |
TRUNCATE |
| DBCC |
NULL |
TRY_CONVERT |
| DEALLOCATE |
NULLIF |
TSEQUAL |
| DECLARE |
OF |
UNION |
| DEFAULT |
OFF |
UNIQUE |
| DELETE |
OFFSETS |
UNPIVOT |
| DENY |
ON |
UPDATE |
| DESC |
OPEN |
UPDATETEXT |
| DISK |
OPENDATASOURCE |
USE |
| DISTINCT |
OPENQUERY |
USER |
| DISTRIBUTED |
OPENROWSET |
VALUES |
| DOUBLE |
OPENXML |
VARYING |
| DROP |
OPTION |
VIEW |
| DUMP |
OR |
WAITFOR |
| ELSE |
ORDER |
Week |
| END |
OUTER |
Weekday |
| ERRLVL |
OVER |
WHEN |
| ESCAPE |
PERCENT |
WHERE |
| EXCEPT |
PIVOT |
WHILE |
| EXEC |
PLAN |
WITH |
| EXECUTE |
PRECISION |
WITHIN GROUP |
| EXISTS |
PRIMARY |
WRITETEXT |
| EXIT |
PRINT |
Year |
| EXTERNAL |
PROC |
Yes |
| FETCH |
PROCEDURE |
YesNo |
| FILE |
PUBLIC |
ODBC reserved keywords
Additionally, the ISO standard defines a list of reserved keywords. Avoid using ISO reserved keywords for object names and identifiers. The ODBC reserved keyword list, shown in the following table, is the same as the ISO reserved keyword list.
The following words are reserved for use in ODBC function calls. These words do not constrain the minimum SQL grammar; however, to ensure compatibility with drivers that support the core SQL grammar, applications should avoid using these keywords.
This is the current list of ODBC reserved keywords.
| Keyword | Keyword | Keyword |
|---|---|---|
| ABSOLUTE |
EXEC |
OVERLAPS |
| ACTION |
EXECUTE |
PAD |
| ADA |
EXISTS |
PARTIAL |
| ADD |
EXTERNAL |
PASCAL |
| ALL |
EXTRACT |
POSITION |
| ALLOCATE |
FALSE |
PRECISION |
| ALTER |
FETCH |
PREPARE |
| AND |
FIRST |
PRESERVE |
| ANY |
FLOAT |
PRIMARY |
| ARE |
FOR |
PRIOR |
| AS |
FOREIGN |
PRIVILEGES |
| ASC |
FORTRAN |
PROCEDURE |
| ASSERTION |
FOUND |
PUBLIC |
| AT |
FROM |
READ |
| AUTHORIZATION |
FULL |
REAL |
| AVG |
GET |
REFERENCES |
| BEGIN |
GLOBAL |
RELATIVE |
| BETWEEN |
GO |
RESTRICT |
| BIT |
GOTO |
REVOKE |
| BIT_LENGTH |
GRANT |
RIGHT |
| BOTH |
GROUP |
ROLLBACK |
| BY |
HAVING |
ROWS |
| CASCADE |
HOUR |
SCHEMA |
| CASCADED |
IDENTITY |
SCROLL |
| CASE |
IMMEDIATE |
SECOND |
| CAST |
IN |
SECTION |
| CATALOG |
INCLUDE |
SELECT |
| CHAR |
INDEX |
SESSION |
| CHAR_LENGTH |
INDICATOR |
SESSION_USER |
| CHARACTER |
INITIALLY |
SET |
| CHARACTER_LENGTH |
INNER |
SIZE |
| CHECK |
INPUT |
SMALLINT |
| CLOSE |
INSENSITIVE |
SOME |
| COALESCE |
INSERT |
SPACE |
| COLLATE |
INT |
SQL |
| COLLATION |
INTEGER |
SQLCA |
| COLUMN |
INTERSECT |
SQLCODE |
| COMMIT |
INTERVAL |
SQLERROR |
| CONNECT |
INTO |
SQLSTATE |
| CONNECTION |
IS |
SQLWARNING |
| CONSTRAINT |
ISOLATION |
SUBSTRING |
| CONSTRAINTS |
JOIN |
SUM |
| CONTINUE |
KEY |
SYSTEM_USER |
| CONVERT |
LANGUAGE |
TABLE |
| CORRESPONDING |
LAST |
TEMPORARY |
| COUNT |
LEADING |
THEN |
| CREATE |
LEFT |
TIME |
| CROSS |
LEVEL |
TIMESTAMP |
| CURRENT |
LIKE |
TIMEZONE_HOUR |
| CURRENT_DATE |
LOCAL |
TIMEZONE_MINUTE |
| CURRENT_TIME |
LOWER |
TO |
| CURRENT_TIMESTAMP |
MATCH |
TRAILING |
| CURRENT_USER |
MAX |
TRANSACTION |
| CURSOR |
MIN |
TRANSLATE |
| DATE |
MINUTE |
TRANSLATION |
| DAY |
MODULE |
TRIM |
| DEALLOCATE |
MONTH |
TRUE |
| DEC |
NAMES |
UNION |
| DECIMAL |
NATIONAL |
UNIQUE |
| DECLARE |
NATURAL |
UNKNOWN |
| DEFAULT |
NCHAR |
UPDATE |
| DEFERRABLE |
NEXT |
UPPER |
| DEFERRED |
NO |
USAGE |
| DELETE |
NONE |
USER |
| DESC |
NOT |
USING |
| DESCRIBE |
NULL |
VALUE |
| DESCRIPTOR |
NULLIF |
VALUES |
| DIAGNOSTICS |
NUMERIC |
VARCHAR |
| DISCONNECT |
OCTET_LENGTH |
VARYING |
| DISTINCT |
OF |
VIEW |
| DOMAIN |
ON |
WHEN |
| DOUBLE |
ONLY |
WHENEVER |
| DROP |
OPEN |
WHERE |
| ELSE |
OPTION |
WITH |
| END |
OR |
WORK |
| END-EXEC |
ORDER |
WRITE |
| ESCAPE |
OUTER |
YEAR |
| EXCEPT |
OUTPUT |
ZONE |
| EXCEPTION |
Future keywords
The following keywords could be reserved in future releases of SQL Server as new features are implemented. Consider avoiding the use of these words as identifiers.
| Keyword | Keyword | Keyword |
|---|---|---|
| ABSOLUTE |
HOST |
RELATIVE |
| ACTION |
HOUR |
RELEASE |
| ADMIN |
IGNORE |
RESULT |
| AFTER |
IMMEDIATE |
RETURNS |
| AGGREGATE |
INDICATOR |
ROLE |
| ALIAS |
INITIALIZE |
ROLLUP |
| ALLOCATE |
INITIALLY |
ROUTINE |
| ARE |
INOUT |
ROW |
| ARRAY |
INPUT |
ROWS |
| ASENSITIVE |
INT |
SAVEPOINT |
| ASSERTION |
INTEGER |
SCROLL |
| ASYMMETRIC |
INTERSECTION |
SCOPE |
| AT |
INTERVAL |
SEARCH |
| ATOMIC |
ISOLATION |
SECOND |
| BEFORE |
ITERATE |
SECTION |
| BINARY |
LANGUAGE |
SENSITIVE |
| BIT |
LARGE |
SEQUENCE |
| BLOB |
LAST |
SESSION |
| BOOLEAN |
LATERAL |
SETS |
| BOTH |
LEADING |
SIMILAR |
| BREADTH |
LESS |
SIZE |
| CALL |
LEVEL |
SMALLINT |
| CALLED |
LIKE_REGEX |
SPACE |
| CARDINALITY |
LIMIT |
SPECIFIC |
| CASCADED |
LN |
SPECIFICTYPE |
| CAST |
LOCAL |
SQL |
| CATALOG |
LOCALTIME |
SQLEXCEPTION |
| CHAR |
LOCALTIMESTAMP |
SQLSTATE |
| CHARACTER |
LOCATOR |
SQLWARNING |
| CLASS |
MAP |
START |
| CLOB |
MATCH |
STATE |
| COLLATION |
MEMBER |
STATEMENT |
| COLLECT |
METHOD |
STATIC |
| COMPLETION |
MINUTE |
STDDEV_POP |
| CONDITION |
MOD |
STDDEV_SAMP |
| CONNECT |
MODIFIES |
STRUCTURE |
| CONNECTION |
MODIFY |
SUBMULTISET |
| CONSTRAINTS |
MODULE |
SUBSTRING_REGEX |
| CONSTRUCTOR |
MONTH |
SYMMETRIC |
| CORR |
MULTISET |
SYSTEM |
| CORRESPONDING |
NAMES |
TEMPORARY |
| COVAR_POP |
NATURAL |
TERMINATE |
| COVAR_SAMP |
NCHAR |
THAN |
| CUBE |
NCLOB |
TIME |
| CUME_DIST |
NEW |
TIMESTAMP |
| CURRENT_CATALOG |
NEXT |
TIMEZONE_HOUR |
| CURRENT_DEFAULT_TRANSFORM_GROUP |
NO |
TIMEZONE_MINUTE |
| CURRENT_PATH |
NONE |
TRAILING |
| CURRENT_ROLE |
NORMALIZE |
TRANSLATE_REGEX |
| CURRENT_SCHEMA |
NUMERIC |
TRANSLATION |
| CURRENT_TRANSFORM_GROUP_FOR_TYPE |
OBJECT |
TREAT |
| CYCLE |
OCCURRENCES_REGEX |
TRUE |
| DATA |
OLD |
UESCAPE |
| DATE |
ONLY |
UNDER |
| DAY |
OPERATION |
UNKNOWN |
| DEC |
ORDINALITY |
UNNEST |
| DECIMAL |
OUT |
USAGE |
| DEFERRABLE |
OVERLAY |
USING |
| DEFERRED |
OUTPUT |
VALUE |
| DEPTH |
PAD |
VAR_POP |
| DEREF |
PARAMETER |
VAR_SAMP |
| DESCRIBE |
PARAMETERS |
VARCHAR |
| DESCRIPTOR |
PARTIAL |
VARIABLE |
| DESTROY |
PARTITION |
WHENEVER |
| DESTRUCTOR |
PATH |
WIDTH_BUCKET |
| DETERMINISTIC |
POSTFIX |
WITHOUT |
| DICTIONARY |
PREFIX |
WINDOW |
| DIAGNOSTICS |
PREORDER |
WITHIN |
| DISCONNECT |
PREPARE |
WORK |
| DOMAIN |
PERCENT_RANK |
WRITE |
| DYNAMIC |
PERCENTILE_CONT |
XMLAGG |
| EACH |
PERCENTILE_DISC |
XMLATTRIBUTES |
| ELEMENT |
POSITION_REGEX |
XMLBINARY |
| END-EXEC |
PRESERVE |
XMLCAST |
| EQUALS |
PRIOR |
XMLCOMMENT |
| EVERY |
PRIVILEGES |
XMLCONCAT |
| EXCEPTION |
RANGE |
XMLDOCUMENT |
| FALSE |
READS |
XMLELEMENT |
| FILTER |
REAL |
XMLEXISTS |
| FIRST |
RECURSIVE |
XMLFOREST |
| FLOAT |
REF |
XMLITERATE |
| FOUND |
REFERENCING |
XMLNAMESPACES |
| FREE |
REGR_AVGX |
XMLPARSE |
| FULLTEXTTABLE |
REGR_AVGY |
XMLPI |
| FUSION |
REGR_COUNT |
XMLQUERY |
| GENERAL |
REGR_INTERCEPT |
XMLSERIALIZE |
| GET |
REGR_R2 |
XMLTABLE |
| GLOBAL |
REGR_SLOPE |
XMLTEXT |
| GO |
REGR_SXX |
XMLVALIDATE |
| GROUPING |
REGR_SXY |
YEAR |
| HOLD |
REGR_SYY |
ZONE |