Vendor-reserved Words
with regard to the SQL-2003 standard
The following table lists the words reserved in DB2, MySQL, Oracle, PostgreSQL and SQL Server.
We have compiled the list based on the documentation that accompanies the software packages.
Some of you might notice that the Mimer SQL column is empty. This is because, in Mimer SQL,
all you need to know is which words are reserved in the SQL standard. Our Mimer SQL extensions don't require
any vendor-reserved words.
| DB2 7 |
Mimer SQL 8 |
MySQL 4 |
Oracle 9i |
PostgreSQL 7 |
SQL Server 2000 |
| |
|
|
ACCESS |
|
|
| ACQUIRE |
|
|
|
|
|
| AFTER |
|
|
|
|
|
| ALIAS |
|
|
|
|
|
| ALLOW |
|
|
|
|
|
| |
|
|
|
ANALYSE |
|
| |
|
ANALYZE |
|
ANALYZE |
|
| ASC |
|
ASC |
ASC |
ASC |
ASC |
| ASUTIME |
|
|
|
|
|
| AUDIT |
|
|
AUDIT |
|
|
| |
|
AUTO_INCREMENT |
|
|
|
| AUX |
|
|
|
|
|
| AUXILIARY |
|
|
|
|
|
| |
|
|
|
|
BACKUP |
| |
|
BDB |
|
|
|
| BEFORE |
|
|
|
|
|
| |
|
BERKLEYDB |
|
|
|
| |
|
|
|
|
BREAK |
| |
|
|
|
|
BROWSE |
| BUFFERPOOL |
|
|
|
|
|
| |
|
|
|
|
BULK |
| CAPTURE |
|
|
|
|
|
| |
|
CASCADE |
|
|
CASCADE |
| CCSID |
|
|
|
|
|
| |
|
CHANGE |
|
|
|
| |
|
|
|
|
CHECKPOINT |
| CLUSTER |
|
|
CLUSTER |
|
|
| |
|
|
|
|
CLUSTERED |
| COLLECTION |
|
|
|
|
|
| COLLID |
|
|
|
|
|
| |
|
COLUMNS |
|
|
|
| COMMENT |
|
|
COMMENT |
|
|
| |
|
|
COMPRESS |
|
|
| |
|
|
|
|
COMPUTE |
| CONCAT |
|
|
|
|
|
| CONNECTION |
|
|
|
|
|
| CONTAINS |
|
|
|
|
CONTAINS |
| |
|
|
|
|
CONTAINSTABLE |
| COUNT_BIG |
|
|
|
|
|
| CURRENT_LC_PATH |
|
|
|
|
|
| CURRENT_SERVER |
|
|
|
|
|
| CURRENT_TIMEZONE |
|
|
|
|
|
| DATA |
|
|
|
|
|
| DATABASE |
|
DATABASE |
|
|
DATABASE |
| |
|
DATABASES |
|
|
|
| |
|
DAY_HOUR |
|
|
|
| |
|
DAY_MINUTE |
|
|
|
| |
|
DAY_SECOND |
|
|
|
| DAYS |
|
|
|
|
|
| DB2GENERAL |
|
|
|
|
|
| DB2SQL |
|
|
|
|
|
| DBA |
|
|
|
|
|
| |
|
|
|
|
DBCC |
| DBINFO |
|
|
|
|
|
| DBSPACE |
|
|
|
|
|
| |
|
|
|
DEFERRABLE |
|
| |
|
DELAYED |
|
|
|
| |
|
|
|
|
DENY |
| DESC |
|
DESC |
DESC |
DESC |
DESC |
| DESCRIPTOR |
|
|
|
|
|
| DISALLOW |
|
|
|
|
|
| |
|
|
|
|
DISK |
| |
|
DISTINCTROW |
|
|
|
| |
|
|
|
|
DISTRIBUTED |
| DSSIZE |
|
|
|
|
|
| |
|
|
|
|
DUMMY |
| |
|
|
|
|
DUMP |
| EDITPROC |
|
|
|
|
|
| |
|
ENCLOSED |
|
|
|
| ERASE |
|
|
|
|
|
| |
|
|
|
|
ERRLVL |
| |
|
ESCAPED |
|
|
|
| EXCEPTION |
|
|
|
|
|
| EXCLUSIVE |
|
|
EXCLUSIVE |
|
|
| EXPLAIN |
|
EXPLAIN |
|
|
|
| FENCED |
|
|
|
|
|
| FIELDPROC |
|
|
|
|
|
| |
|
FIELDS |
|
|
|
| FILE |
|
|
FILE |
|
FILE |
| |
|
|
|
|
FILLFACTOR |
| FINAL |
|
|
|
|
|
| |
|
|
|
|
FREETEXT |
| |
|
|
|
|
FREETEXTTABLE |
| |
|
FULLTEXT |
|
|
|
| GENERAL |
|
|
|
|
|
| GENERATED |
|
|
|
|
|
| GO |
|
|
|
|
|
| GOTO |
|
|
|
|
GOTO |
| GRAPHIC |
|
|
|
|
|
| |
|
HIGH_PRIORITY |
|
|
|
| |
|
|
|
|
HOLDLOCK |
| |
|
HOUR_MINUTE |
|
|
|
| |
|
HOUR_SECOND |
|
|
|
| HOURS |
|
|
|
|
|
| IDENTIFIED |
|
|
IDENTIFIED |
|
|
| |
|
|
|
|
IDENTITY_INSERT |
| |
|
|
|
|
IDENTITYCOL |
| |
|
IGNORE |
|
|
|
| |
|
|
|
ILIKE |
|
| |
|
|
INCREMENT |
|
|
| INDEX |
|
INDEX |
INDEX |
|
INDEX |
| |
|
INFILE |
|
|
|
| |
|
|
INITIAL |
|
|
| |
|
|
|
INITIALLY |
|
| |
|
INNODB |
|
|
|
| |
|
INSERT_ID |
|
|
|
| INTEGRITY |
|
|
|
|
|
| |
|
|
|
ISNULL |
|
| ISOBID |
|
|
|
|
|
| ISOLATION |
|
|
|
|
|
| JAVA |
|
|
|
|
|
| KEY |
|
KEY |
|
|
KEY |
| |
|
KEYS |
|
|
|
| |
|
KILL |
|
|
KILL |
| LABEL |
|
|
|
|
|
| |
|
LAST_INSERT_ID |
|
|
|
| LC_CTYPE |
|
|
|
|
|
| |
|
LIMIT |
|
LIMIT |
|
| |
|
|
|
|
LINENO |
| |
|
LINES |
|
|
|
| LINKTYPE |
|
|
|
|
|
| |
|
LOAD |
|
|
LOAD |
| LOCALE |
|
|
|
|
|
| LOCATOR |
|
|
|
|
|
| LOCATORS |
|
|
|
|
|
| LOCK |
|
LOCK |
LOCK |
|
|
| LOCKSIZE |
|
|
|
|
|
| LONG |
|
LONG |
LONG |
|
|
| |
|
LONGBLOB |
|
|
|
| |
|
LONGTEXT |
|
|
|
| |
|
LOW_PRIORITY |
|
|
|
| |
|
MASTER_LOG_SEQ |
|
|
|
| |
|
MASTER_SERVER_ID |
|
|
|
| |
|
|
MAXEXTENTS |
|
|
| |
|
MEDIUMBLOB |
|
|
|
| |
|
MEDIUMINT |
|
|
|
| |
|
MEDIUMTEXT |
|
|
|
| MICROSECOND |
|
|
|
|
|
| MICROSECONDS |
|
|
|
|
|
| |
|
MIDDLEINT |
|
|
|
| |
|
|
MINUS |
|
|
| |
|
MINUTE_SECOND |
|
|
|
| MINUTES |
|
|
|
|
|
| |
|
|
MLSLABEL |
|
|
| MODE |
|
|
MODE |
|
|
| |
|
|
MODIFY |
|
|
| MONTHS |
|
|
|
|
|
| |
|
MRG_MYISAM |
|
|
|
| NAME |
|
|
|
|
|
| NAMED |
|
|
|
|
|
| NHEADER |
|
|
|
|
|
| |
|
|
NOAUDIT |
|
|
| |
|
|
|
|
NOCHECK |
| |
|
|
NOCOMPRESS |
|
|
| NODENAME |
|
|
|
|
|
| NODENUMBER |
|
|
|
|
|
| |
|
|
|
|
NONCLUSTERED |
| |
|
|
|
NOTNULL |
|
| |
|
|
NOWAIT |
|
|
| NULLS |
|
|
|
|
|
| |
|
|
NUMBER |
|
|
| NUMPARTS |
|
|
|
|
|
| OBID |
|
|
|
|
|
| |
|
|
|
OFF |
OFF |
| |
|
|
OFFLINE |
|
|
| |
|
|
|
OFFSET |
|
| |
|
|
|
|
OFFSETS |
| |
|
|
ONLINE |
|
|
| |
|
|
|
|
OPENDATASOURCE |
| |
|
|
|
|
OPENQUERY |
| |
|
|
|
|
OPENROWSET |
| |
|
|
|
|
OPENXML |
| OPTIMIZATION |
|
|
|
|
|
| OPTIMIZE |
|
OPTIMIZE |
|
|
|
| OPTION |
|
OPTION |
OPTION |
|
OPTION |
| |
|
OPTIONALLY |
|
|
|
| |
|
OUTFILE |
|
|
|
| PACKAGE |
|
|
|
|
|
| PAGE |
|
|
|
|
|
| PAGES |
|
|
|
|
|
| PART |
|
|
|
|
|
| |
|
PARTIAL |
|
|
|
| PATH |
|
|
|
|
|
| PCTFREE |
|
|
PCTFREE |
|
|
| PCTINDEX |
|
|
|
|
|
| |
|
|
|
|
PERCENT |
| PIECESIZE |
|
|
|
|
|
| PLAN |
|
|
|
|
PLAN |
| |
|
|
|
|
PRINT |
| |
|
|
PRIOR |
|
|
| PRIQTY |
|
|
|
|
|
| PRIVATE |
|
|
|
|
|
| PRIVILEGES |
|
PRIVILEGES |
PRIVILEGES |
|
|
| |
|
|
|
|
PROC |
| PROGRAM |
|
|
|
|
|
| PSID |
|
|
|
|
|
| |
|
PURGE |
|
|
|
| QYERYNO |
|
|
|
|
|
| |
|
|
|
|
RAISERROR |
| |
|
|
RAW |
|
|
| READ |
|
READ |
|
|
READ |
| |
|
|
|
|
READTEXT |
| |
|
|
|
|
RECONFIGURE |
| RECOVERY |
|
|
|
|
|
| |
|
REGEXP |
|
|
|
| RENAME |
|
RENAME |
RENAME |
|
|
| |
|
REPLACE |
|
|
|
| |
|
|
|
|
REPLICATION |
| |
|
REQUIRE |
|
|
|
| RESET |
|
|
|
|
|
| RESOURCE |
|
|
RESOURCE |
|
|
| |
|
|
|
|
RESTORE |
| RESTRICT |
|
RESTRICT |
|
|
RESTRICT |
| RESULT |
|
|
|
|
|
| |
|
RLIKE |
|
|
|
| |
|
|
|
|
ROWCOUNT |
| |
|
|
|
|
ROWGUIDCOL |
| |
|
|
ROWID |
|
|
| |
|
|
ROWNUM |
|
|
| RRN |
|
|
|
|
|
| |
|
|
|
|
RULE |
| RUN |
|
|
|
|
|
| |
|
|
|
|
SAVE |
| SCHEDULE |
|
|
|
|
|
| SCHEMA |
|
|
|
|
SCHEMA |
| SCRATCHPAD |
|
|
|
|
|
| SECONDS |
|
|
|
|
|
| SECQTY |
|
|
|
|
|
| SECURITY |
|
|
|
|
|
| |
|
|
SESSION |
|
|
| |
|
|
|
|
SETUSER |
| SHARE |
|
|
SHARE |
|
|
| |
|
SHOW |
|
|
|
| |
|
|
|
|
SHUTDOWN |
| SIMPLE |
|
|
|
|
|
| |
|
|
SIZE |
|
|
| |
|
SONAME |
|
|
|
| SOURCE |
|
|
|
|
|
| |
|
SQL_AUTO_IS_NULL |
|
|
|
| |
|
SQL_BIG_RESULT |
|
|
|
| |
|
SQL_BIG_SELECTS |
|
|
|
| |
|
SQL_BIG_TABLES |
|
|
|
| |
|
SQL_BUFFER_RESULT |
|
|
|
| |
|
SQL_CALC_FOUND_ROWS |
|
|
|
| |
|
SQL_LOG_BIN |
|
|
|
| |
|
SQL_LOG_OFF |
|
|
|
| |
|
SQL_LOG_UPDATE |
|
|
|
| |
|
SQL_LOW_PRIORITY_UPDATES |
|
|
|
| |
|
SQL_MAX_JOIN_SIZE |
|
|
|
| |
|
SQL_QUOTE_SHOW_CREATE |
|
|
|
| |
|
SQL_SAFE_UPDATES |
|
|
|
| |
|
SQL_SELECT_LIMIT |
|
|
|
| |
|
SQL_SLAVE_SKIP_COUNTER |
|
|
|
| |
|
SQL_SMALL_RESULT |
|
|
|
| |
|
SQL_WARNINGS |
|
|
|
| |
|
SSL |
|
|
|
| STANDARD |
|
|
|
|
|
| |
|
STARTING |
|
|
|
| STATISTICS |
|
|
|
|
STATISTICS |
| STAY |
|
|
|
|
|
| STOGROUP |
|
|
|
|
|
| STORES |
|
|
|
|
|
| STORPOOL |
|
|
|
|
|
| |
|
STRAIGHT_JOIN |
|
|
|
| |
|
STRIPED |
|
|
|
| STYLE |
|
|
|
|
|
| SUBPAGES |
|
|
|
|
|
| |
|
|
SUCCESSFUL |
|
|
| SYNONYM |
|
|
SYNONYM |
|
|
| |
|
|
SYSDATE |
|
|
| |
|
TABLES |
|
|
|
| TABLESPACE |
|
|
|
|
|
| |
|
TERMINATED |
|
|
|
| |
|
|
|
|
TEXTSIZE |
| |
|
TINYBLOB |
|
|
|
| |
|
TINYINT |
|
|
|
| |
|
TINYTEXT |
|
|
|
| |
|
|
|
|
TOP |
| |
|
|
|
|
TRAN |
| TRANSACTION |
|
|
|
|
TRANSACTION |
| |
|
|
|
|
TRUNCATE |
| |
|
|
|
|
TSEQUAL |
| TYPE |
|
|
|
|
|
| |
|
|
UID |
|
|
| |
|
UNLOCK |
|
|
|
| |
|
UNSIGNED |
|
|
|
| |
|
|
|
|
UPDATETEXT |
| USAGE |
|
USAGE |
|
|
|
| |
|
USE |
|
|
USE |
| |
|
|
VALIDATE |
|
|
| VALIDPROC |
|
|
|
|
|
| |
|
|
VARCHAR2 |
|
|
| VARIABLE |
|
|
|
|
|
| VARIANT |
|
|
|
|
|
| VCAT |
|
|
|
|
|
| |
|
|
|
VERBOSE |
|
| VIEW |
|
|
VIEW |
|
VIEW |
| VOLUMES |
|
|
|
|
|
| |
|
|
|
|
WAITFOR |
| WLM |
|
|
|
|
|
| WORK |
|
|
|
|
|
| WRITE |
|
WRITE |
|
|
|
| |
|
|
|
|
WRITETEXT |
| |
|
YEAR_MONTH |
|
|
|
| YEARS |
|
|
|
|
|
| |
|
ZEROFILL |
|
|
|
|
