Jump to content

List of SQL reserved words

From Wikipedia, the free encyclopedia

This list includes SQL reserved words – aka SQL reserved keywords,[1][2] as the SQL:2023 specifies and some RDBMSs have added.


Reserved words in SQL and related products
In SQL:2023[3] In IBM Db2 13[4] In Mimer SQL 11.0[5] In MySQL 8.0[6] In Oracle Database 23c[7] In PostgreSQL 16[1] In Microsoft SQL Server 2022[2] In Teradata 15[8]
ABORT Teradata
ABORTSESSION Teradata
ABS SQL-2023 Teradata
ABSENT SQL-2023
ABSOLUTE Teradata
ACCESS Oracle
ACCESSIBLE MySQL
ACCESS_LOCK Teradata
ACCOUNT Teradata
ACOS SQL-2023 Teradata
ACOSH Teradata
ACTION Teradata
ADD DB2 MySQL Oracle SQL Server Teradata
ADD_MONTHS Teradata
ADMIN Teradata
AFTER DB2 Teradata
AGGREGATE Teradata
ALIAS Teradata
ALL SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ALLOCATE SQL-2023 DB2 Mimer Teradata
ALLOW DB2
ALTER SQL-2023 Mimer MySQL Oracle SQL Server Teradata
ALTERAND DB2
AMP Teradata
ANALYSE PostgreSQL
ANALYZE MySQL PostgreSQL
AND SQL-2023 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ANSIDATE Teradata
ANY SQL-2023 DB2 Mimer Oracle PostgreSQL SQL Server Teradata
ANY_VALUE SQL-2023
ARE SQL-2023 Teradata
ARRAY SQL-2023 DB2 PostgreSQL Teradata
ARRAY_AGG SQL-2023
ARRAY_EXISTS DB2
ARRAY_MAX_CARDINALITY SQL-2023
AS SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ASC MySQL Oracle PostgreSQL SQL Server Teradata
ASENSITIVE SQL-2023 DB2 MySQL
ASIN SQL-2023 Teradata
ASINH Teradata
ASSERTION Teradata
ASSOCIATE DB2
ASUTIME DB2
ASYMMETRIC SQL-2023 Mimer PostgreSQL
AT SQL-2023 DB2 Mimer Teradata
ATAN SQL-2023 Teradata
ATAN2 Teradata
ATANH Teradata
ATOMIC SQL-2023 Mimer Teradata
AUDIT DB2 Oracle
AUTHORIZATION SQL-2023 Mimer PostgreSQL SQL Server Teradata
AUX DB2
AUXILIARY DB2
AVE Teradata
AVERAGE Teradata
AVG SQL-2023 Teradata
BACKUP SQL Server
BEFORE DB2 MySQL Teradata
BEGIN SQL-2023 DB2 Mimer SQL Server Teradata
BEGIN_FRAME SQL-2023
BEGIN_PARTITION SQL-2023
BETWEEN SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
BIGINT SQL-2023 MySQL
BINARY SQL-2023 MySQL PostgreSQL Teradata
BIT Teradata
BLOB SQL-2023 MySQL Teradata
BOOLEAN SQL-2023 Teradata
BOTH SQL-2023 Mimer MySQL PostgreSQL Teradata
BREADTH Teradata
BREAK SQL Server
BROWSE SQL Server
BT Teradata
BTRIM SQL-2023
BUFFERPOOL DB2
BULK SQL Server
BUT Teradata
BY SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
BYTE Teradata
BYTEINT Teradata
BYTES Teradata
CALL SQL-2023 DB2 Mimer MySQL Teradata
CALLED SQL-2023 Mimer
CAPTURE DB2
CARDINALITY SQL-2023
CASCADE MySQL SQL Server Teradata
CASCADED SQL-2023 DB2 Teradata
CASE SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
CASESPECIFIC Teradata
CASE_N Teradata
CAST SQL-2023 DB2 Mimer PostgreSQL Teradata
CATALOG Teradata
CCSID DB2
CD Teradata
CEIL SQL-2023
CEILING SQL-2023
CHANGE MySQL
CHAR SQL-2023 DB2 MySQL Oracle Teradata
CHAR2HEXINT Teradata
CHARACTER SQL-2023 DB2 MySQL Teradata
CHARACTERS Teradata
CHARACTER_LENGTH SQL-2023 Teradata
CHARS Teradata
CHAR_LENGTH SQL-2023 Teradata
CHECK SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
CHECKPOINT SQL Server Teradata
CLASS Teradata
CLASSIFIER SQL-2023
CLOB SQL-2023 Teradata
CLONE DB2
CLOSE SQL-2023 DB2 Mimer SQL Server Teradata
CLUSTER DB2 Oracle Teradata
CLUSTERED SQL Server
CM Teradata
COALESCE SQL-2023 SQL Server Teradata
COLLATE SQL-2023 Mimer MySQL PostgreSQL SQL Server Teradata
COLLATION PostgreSQL Teradata
COLLECT SQL-2023 Teradata
COLLECTION DB2
COLLID DB2
COLUMN SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
COLUMN_VALUE Oracle
COMMENT DB2 Oracle Teradata
COMMIT SQL-2023 DB2 Mimer SQL Server Teradata
COMPLETION Teradata
COMPRESS Oracle Teradata
COMPUTE SQL Server
CONCAT DB2
CONCURRENTLY PostgreSQL
CONDITION SQL-2023 DB2 Mimer MySQL
CONNECT SQL-2023 DB2 Mimer Oracle Teradata
CONNECTION DB2 Teradata
CONSTRAINT SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
CONSTRAINTS Teradata
CONSTRUCTOR Teradata
CONTAINS SQL-2023 DB2 SQL Server
CONTAINSTABLE SQL Server
CONTENT DB2
CONTINUE DB2 MySQL SQL Server Teradata
CONVERT SQL-2023 MySQL SQL Server
CONVERT_TABLE_HEADER Teradata
COPY SQL-2023
CORR SQL-2023 Teradata
CORRESPONDING SQL-2023 Mimer Teradata
COS SQL-2023 Teradata
COSH SQL-2023 Teradata
COUNT SQL-2023 Teradata
COVAR_POP SQL-2023 Teradata
COVAR_SAMP SQL-2023 Teradata
CREATE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
CROSS SQL-2023 Mimer MySQL PostgreSQL SQL Server Teradata
CS Teradata
CSUM Teradata
CT Teradata
CUBE SQL-2023 DB2 MySQL Teradata
CUME_DIST SQL-2023 MySQL
CURRENT SQL-2023 DB2 Mimer Oracle SQL Server Teradata
CURRENT_CATALOG SQL-2023 PostgreSQL
CURRENT_DATE SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
CURRENT_DEFAULT_TRANSFORM_GROUP SQL-2023
CURRENT_LC_CTYPE DB2
CURRENT_PATH SQL-2023 DB2 Mimer Teradata
CURRENT_ROLE SQL-2023 PostgreSQL Teradata
CURRENT_ROW SQL-2023
CURRENT_SCHEMA SQL-2023 DB2 PostgreSQL
CURRENT_SERVER DB2
CURRENT_TIME SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
CURRENT_TIMESTAMP SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
CURRENT_TIMEZONE DB2
CURRENT_TRANSFORM_GROUP_FOR_TYPE SQL-2023
CURRENT_USER SQL-2023 Mimer MySQL PostgreSQL SQL Server Teradata
CURRVAL DB2
CURSOR SQL-2023 DB2 Mimer MySQL SQL Server Teradata
CV Teradata
CYCLE SQL-2023 Teradata
DATA DB2 Teradata
DATABASE DB2 MySQL SQL Server Teradata
DATABASES MySQL
DATABLOCKSIZE Teradata
DATE SQL-2023 Oracle Teradata
DATEFORM Teradata
DAY SQL-2023 DB2 Mimer Teradata
DAYS DB2
DAY_HOUR MySQL
DAY_MICROSECOND MySQL
DAY_MINUTE MySQL
DAY_SECOND MySQL
DBCC SQL Server
DBINFO DB2
DEALLOCATE SQL-2023 Mimer SQL Server Teradata
DEC SQL-2023 MySQL Teradata
DECFLOAT SQL-2023
DECIMAL SQL-2023 MySQL Oracle Teradata
DECLARE SQL-2023 DB2 Mimer MySQL SQL Server Teradata
DEFAULT SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
DEFERRABLE PostgreSQL Teradata
DEFERRED Teradata
DEFINE SQL-2023
DEGREES Teradata
DEL Teradata
DELAYED MySQL
DELETE SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
DENSE_RANK SQL-2023 MySQL
DENY SQL Server
DEPTH Teradata
DEREF SQL-2023 Teradata
DESC MySQL Oracle PostgreSQL SQL Server Teradata
DESCRIBE SQL-2023 Mimer MySQL Teradata
DESCRIPTOR DB2 Teradata
DESTROY Teradata
DESTRUCTOR Teradata
DETERMINISTIC SQL-2023 DB2 Mimer MySQL Teradata
DIAGNOSTIC Teradata
DIAGNOSTICS Teradata
DICTIONARY Teradata
DISABLE DB2
DISABLED Teradata
DISALLOW DB2
DISCONNECT SQL-2023 Mimer Teradata
DISK SQL Server
DISTINCT SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
DISTINCTROW MySQL
DISTRIBUTED SQL Server
DIV MySQL
DO SQL/PSM-2016 DB2 Mimer PostgreSQL Teradata
DOCUMENT DB2
DOMAIN Teradata
DOUBLE SQL-2023 DB2 MySQL SQL Server Teradata
DROP SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
DSSIZE DB2
DUAL MySQL Teradata
DUMP SQL Server Teradata
DYNAMIC SQL-2023 DB2 Teradata
EACH SQL-2023 MySQL Teradata
ECHO Teradata
EDITPROC DB2
ELEMENT SQL-2023
ELSE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ELSEIF SQL/PSM-2016 DB2 Mimer MySQL Teradata
EMPTY SQL-2023 MySQL
ENABLED Teradata
ENCLOSED MySQL
ENCODING DB2
ENCRYPTION DB2
END SQL-2023 DB2 Mimer PostgreSQL SQL Server Teradata
END-EXEC SQL-2023 DB2 Teradata
ENDING DB2
END_FRAME SQL-2023
END_PARTITION SQL-2023
EQ Teradata
EQUALS SQL-2023 Teradata
ERASE DB2
ERRLVL SQL Server
ERROR Teradata
ERRORFILES Teradata
ERRORTABLES Teradata
ESCAPE SQL-2023 DB2 Mimer SQL Server Teradata
ESCAPED MySQL
ET Teradata
EVERY SQL-2023 Teradata
EXCEPT SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
EXCEPTION DB2 Teradata
EXCLUSIVE Oracle
EXEC SQL-2023 SQL Server Teradata
EXECUTE SQL-2023 DB2 Mimer SQL Server Teradata
EXISTS SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
EXIT DB2 MySQL SQL Server Teradata
EXP SQL-2023 Teradata
EXPLAIN DB2 MySQL Teradata
EXTERNAL SQL-2023 DB2 Mimer SQL Server Teradata
EXTRACT SQL-2023 Teradata
FALLBACK Teradata
FALSE SQL-2023 Mimer MySQL PostgreSQL Teradata
FASTEXPORT Teradata
FENCED DB2
FETCH SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
FIELDPROC DB2
FILE Oracle SQL Server
FILLFACTOR SQL Server
FILTER SQL-2023
FINAL DB2
FIRST DB2 Mimer Teradata
FIRST_VALUE SQL-2023 MySQL
FLOAT SQL-2023 MySQL Oracle Teradata
FLOAT4 MySQL
FLOAT8 MySQL
FLOOR SQL-2023
FOR SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
FORCE MySQL
FOREIGN SQL-2023 Mimer MySQL PostgreSQL SQL Server Teradata
FORMAT Teradata
FOUND Teradata
FRAME_ROW SQL-2023
FREE SQL-2023 DB2 Teradata
FREESPACE Teradata
FREETEXT SQL Server
FREETEXTTABLE SQL Server
FREEZE PostgreSQL
FROM SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
FULL SQL-2023 DB2 Mimer PostgreSQL SQL Server Teradata
FULLTEXT MySQL
FUNCTION SQL-2023 DB2 Mimer MySQL SQL Server Teradata
FUSION SQL-2023
GE Teradata
GENERAL Teradata
GENERATED DB2 MySQL Teradata
GET SQL-2023 DB2 Mimer MySQL Teradata
GIVE Teradata
GLOBAL SQL-2023 DB2 Mimer Teradata
GO DB2 Teradata
GOTO DB2 SQL Server Teradata
GRANT SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
GRAPHIC Teradata
GREATEST SQL-2023
GROUP SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
GROUPING SQL-2023 MySQL Teradata
GROUPS SQL-2023 MySQL
GT Teradata
HANDLER SQL/PSM-2016 DB2 Mimer Teradata
HASH Teradata
HASHAMP Teradata
HASHBAKAMP Teradata
HASHBUCKET Teradata
HASHROW Teradata
HAVING SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
HELP Teradata
HIGH_PRIORITY MySQL
HOLD SQL-2023 DB2 Mimer
HOLDLOCK SQL Server
HOST Teradata
HOUR SQL-2023 DB2 Mimer Teradata
HOURS DB2
HOUR_MICROSECOND MySQL
HOUR_MINUTE MySQL
HOUR_SECOND MySQL
IDENTIFIED Oracle
IDENTITY SQL-2023 Mimer SQL Server Teradata
IDENTITYCOL SQL Server
IDENTITY_INSERT SQL Server
IF SQL/PSM-2016 DB2 Mimer MySQL SQL Server Teradata
IGNORE MySQL Teradata
ILIKE PostgreSQL
IMMEDIATE DB2 Oracle Teradata
IN SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
INCLUSIVE DB2
INCONSISTENT Teradata
INCREMENT Oracle
INDEX DB2 MySQL Oracle SQL Server Teradata
INDICATOR SQL-2023 Mimer Teradata
INFILE MySQL
INHERIT DB2
INITIAL SQL-2023 Oracle
INITIALIZE Teradata
INITIALLY PostgreSQL Teradata
INITIATE Teradata
INNER SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
INOUT SQL-2023 DB2 Mimer MySQL Teradata
INPUT Teradata
INS Teradata
INSENSITIVE SQL-2023 DB2 MySQL
INSERT SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
INSTEAD Teradata
INT SQL-2023 MySQL Teradata
INT1 MySQL
INT2 MySQL
INT3 MySQL
INT4 MySQL
INT8 MySQL
INTEGER SQL-2023 MySQL Oracle Teradata
INTEGERDATE Teradata
INTERSECT SQL-2023 DB2 Mimer Oracle PostgreSQL SQL Server Teradata
INTERSECTION SQL-2023
INTERVAL SQL-2023 Mimer MySQL Teradata
INTO SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
IO_AFTER_GTIDS MySQL
IO_BEFORE_GTIDS MySQL
IS SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ISNULL PostgreSQL
ISOBID DB2
ISOLATION Teradata
ITERATE SQL/PSM-2016 DB2 Mimer MySQL Teradata
JAR DB2
JOIN SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
JOURNAL Teradata
JSON SQL-2023
JSON_ARRAY SQL-2023
JSON_ARRAYAGG SQL-2023
JSON_EXISTS SQL-2023
JSON_OBJECT SQL-2023
JSON_OBJECTAGG SQL-2023
JSON_QUERY SQL-2023
JSON_SCALAR SQL-2023
JSON_SERIALIZE SQL-2023
JSON_TABLE SQL-2023 MySQL
JSON_TABLE_PRIMITIVE SQL-2023
JSON_VALUE SQL-2023
KEEP DB2
KEY DB2 MySQL SQL Server Teradata
KEYS MySQL
KILL MySQL SQL Server
KURTOSIS Teradata
LABEL DB2
LAG SQL-2023 MySQL
LANGUAGE SQL-2023 DB2 Mimer Teradata
LARGE SQL-2023 Mimer Teradata
LAST DB2 Teradata
LAST_VALUE SQL-2023 MySQL
LATERAL SQL-2023 MySQL PostgreSQL Teradata
LC_CTYPE DB2
LE Teradata
LEAD SQL-2023 MySQL
LEADING SQL-2023 Mimer MySQL PostgreSQL Teradata
LEAST SQL-2023
LEAVE SQL/PSM-2016 DB2 Mimer MySQL Teradata
LEFT SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
LESS Teradata
LEVEL Oracle Teradata
LIKE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
LIKE_REGEX SQL-2023
LIMIT DB2 MySQL PostgreSQL Teradata
LINEAR MySQL
LINENO SQL Server
LINES MySQL
LISTAGG SQL-2023
LN SQL-2023 Teradata
LOAD MySQL SQL Server
LOADING Teradata
LOCAL SQL-2023 DB2 Mimer Teradata
LOCALE DB2
LOCALTIME SQL-2023 Mimer MySQL PostgreSQL Teradata
LOCALTIMESTAMP SQL-2023 Mimer MySQL PostgreSQL Teradata
LOCATOR DB2 Teradata
LOCATORS DB2
LOCK DB2 MySQL Oracle Teradata
LOCKING Teradata
LOCKMAX DB2
LOCKSIZE DB2
LOG SQL-2023 Teradata
LOG10 SQL-2023
LOGGING Teradata
LOGON Teradata
LONG DB2 MySQL Oracle Teradata
LONGBLOB MySQL
LONGTEXT MySQL
LOOP SQL/PSM-2016 DB2 Mimer MySQL Teradata
LOWER SQL-2023 Teradata
LOW_PRIORITY MySQL
LPAD SQL-2023
LT Teradata
LTRIM SQL-2023
MACRO Teradata
MAINTAINED DB2
MAP Teradata
MASTER_BIND MySQL
MASTER_SSL_VERIFY_SERVER_CERT MySQL
MATCH SQL-2023 Mimer MySQL Teradata
MATCHES SQL-2023
MATCH_NUMBER SQL-2023
MATCH_RECOGNIZE SQL-2023
MATERIALIZED DB2
MAVG Teradata
MAX SQL-2023 Teradata
MAXEXTENTS Oracle
MAXIMUM Teradata
MAXVALUE MySQL
MCHARACTERS Teradata
MDIFF Teradata
MEDIUMBLOB MySQL
MEDIUMINT MySQL
MEDIUMTEXT MySQL
MEMBER SQL-2023 Mimer
MERGE SQL-2023 SQL Server Teradata
METHOD SQL-2023 Mimer
MICROSECOND DB2
MICROSECONDS DB2
MIDDLEINT MySQL
MIN SQL-2023 Teradata
MINDEX Teradata
MINIMUM Teradata
MINUS Oracle Teradata
MINUTE SQL-2023 DB2 Mimer Teradata
MINUTES DB2
MINUTE_MICROSECOND MySQL
MINUTE_SECOND MySQL
MLINREG Teradata
MLOAD Teradata
MLSLABEL Oracle
MOD SQL-2023 MySQL Teradata
MODE Oracle Teradata
MODIFIES SQL-2023 DB2 Mimer MySQL Teradata
MODIFY Oracle Teradata
MODULE SQL-2023 Mimer Teradata
MONITOR Teradata
MONRESOURCE Teradata
MONSESSION Teradata
MONTH SQL-2023 DB2 Mimer Teradata
MONTHS DB2
MSUBSTR Teradata
MSUM Teradata
MULTISET SQL-2023 Teradata
NAMED Teradata
NAMES Teradata
NATIONAL SQL-2023 Mimer SQL Server Teradata
NATURAL SQL-2023 Mimer MySQL PostgreSQL Teradata
NCHAR SQL-2023 Teradata
NCLOB SQL-2023 Teradata
NE Teradata
NESTED_TABLE_ID Oracle
NEW SQL-2023 Mimer Teradata
NEW_TABLE Teradata
NEXT DB2 Mimer Teradata
NEXTVAL DB2
NO SQL-2023 DB2 Mimer Teradata
NOAUDIT Oracle
NOCHECK SQL Server
NOCOMPRESS Oracle
NONCLUSTERED SQL Server
NONE SQL-2023 DB2 Teradata
NORMALIZE SQL-2023
NOT SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
NOTNULL PostgreSQL
NOWAIT Oracle Teradata
NO_WRITE_TO_BINLOG MySQL
NTH_VALUE SQL-2023 MySQL
NTILE SQL-2023 MySQL
NULL SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
NULLIF SQL-2023 SQL Server Teradata
NULLIFZERO Teradata
NULLS DB2
NUMBER Oracle
NUMERIC SQL-2023 MySQL Teradata
NUMPARTS DB2
OBID DB2
OBJECT Teradata
OBJECTS Teradata
OCCURRENCES_REGEX SQL-2023
OCTET_LENGTH SQL-2023 Teradata
OF SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
OFF SQL Server Teradata
OFFLINE Oracle
OFFSET SQL-2023 DB2 Mimer PostgreSQL
OFFSETS SQL Server
OLD SQL-2023 DB2 Mimer Teradata
OLD_TABLE Teradata
OMIT SQL-2023
ON SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ONE SQL-2023
ONLINE Oracle
ONLY SQL-2023 PostgreSQL Teradata
OPEN SQL-2023 DB2 Mimer SQL Server Teradata
OPENDATASOURCE SQL Server
OPENQUERY SQL Server
OPENROWSET SQL Server
OPENXML SQL Server
OPERATION Teradata
OPTIMIZATION DB2
OPTIMIZE DB2 MySQL
OPTIMIZER_COSTS MySQL
OPTION MySQL Oracle SQL Server Teradata
OPTIONALLY MySQL
OR SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ORDER SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
ORDINALITY Teradata
ORGANIZATION DB2
OUT SQL-2023 DB2 Mimer MySQL Teradata
OUTER SQL-2023 DB2 MySQL PostgreSQL SQL Server Teradata
OUTFILE MySQL
OUTPUT Teradata
OVER SQL-2023 MySQL SQL Server Teradata
OVERLAPS SQL-2023 Mimer PostgreSQL Teradata
OVERLAY SQL-2023
OVERRIDE Teradata
PACKAGE DB2
PAD Teradata
PADDED DB2
PARAMETER SQL-2023 DB2 Mimer Teradata
PARAMETERS Teradata
PART DB2
PARTIAL Teradata
PARTITION SQL-2023 DB2 MySQL
PARTITIONED DB2
PARTITIONING DB2
PASSWORD Teradata
PATH DB2 Teradata
PATTERN SQL-2023
PCTFREE Oracle
PER SQL-2023
PERCENT SQL-2023 SQL Server Teradata
PERCENTILE_CONT SQL-2023
PERCENTILE_DISC SQL-2023
PERCENT_RANK SQL-2023 MySQL Teradata
PERIOD SQL-2023 DB2
PERM Teradata
PERMANENT Teradata
PIECESIZE DB2
PIVOT SQL Server
PLACING PostgreSQL
PLAN DB2 SQL Server
PORTION SQL-2023
POSITION SQL-2023 Teradata
POSITION_REGEX SQL-2023
POSTFIX Teradata
POWER SQL-2023
PRECEDES SQL-2023
PRECISION SQL-2023 DB2 Mimer MySQL SQL Server Teradata
PREFIX Teradata
PREORDER Teradata
PREPARE SQL-2023 DB2 Mimer Teradata
PRESERVE Teradata
PREVVAL DB2
PRIMARY SQL-2023 Mimer MySQL PostgreSQL SQL Server Teradata
PRINT SQL Server
PRIOR DB2 Oracle Teradata
PRIQTY DB2
PRIVATE Teradata
PRIVILEGES DB2 Teradata
PROC SQL Server
PROCEDURE SQL-2023 DB2 Mimer MySQL SQL Server Teradata
PROFILE Teradata
PROGRAM DB2
PROPORTIONAL Teradata
PROTECTION Teradata
PSID DB2
PTF SQL-2023
PUBLIC DB2 Oracle SQL Server Teradata
PURGE MySQL
QUALIFIED Teradata
QUALIFY Teradata
QUANTILE Teradata
QUERY DB2
QUERYNO DB2
RADIANS Teradata
RAISERROR SQL Server
RANDOM Teradata
RANGE SQL-2023 MySQL
RANGE_N Teradata
RANK SQL-2023 MySQL Teradata
RAW Oracle
READ MySQL SQL Server Teradata
READS SQL-2023 DB2 Mimer MySQL Teradata
READTEXT SQL Server
READ_WRITE MySQL
REAL SQL-2023 MySQL Teradata
RECONFIGURE SQL Server
RECURSIVE SQL-2023 Mimer MySQL Teradata
REF SQL-2023 Teradata
REFERENCES SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
REFERENCING SQL-2023 Mimer Teradata
REFRESH DB2
REGEXP MySQL
REGR_AVGX SQL-2023 Teradata
REGR_AVGY SQL-2023 Teradata
REGR_COUNT SQL-2023 Teradata
REGR_INTERCEPT SQL-2023 Teradata
REGR_R2 SQL-2023 Teradata
REGR_SLOPE SQL-2023 Teradata
REGR_SXX SQL-2023 Teradata
REGR_SXY SQL-2023 Teradata
REGR_SYY SQL-2023 Teradata
RELATIVE Teradata
RELEASE SQL-2023 DB2 Mimer MySQL Teradata
RENAME DB2 MySQL Oracle Teradata
REPEAT SQL/PSM-2016 DB2 Mimer MySQL Teradata
REPLACE MySQL Teradata
REPLICATION SQL Server Teradata
REPOVERRIDE Teradata
REQUEST Teradata
REQUIRE MySQL
RESIGNAL SQL/PSM-2016 DB2 Mimer MySQL
RESOURCE Oracle
RESTART Teradata
RESTORE SQL Server Teradata
RESTRICT DB2 MySQL SQL Server Teradata
RESULT SQL-2023 DB2 Mimer Teradata
RESULT_SET_LOCATOR DB2
RESUME Teradata
RET Teradata
RETRIEVE Teradata
RETURN SQL-2023 DB2 Mimer MySQL SQL Server Teradata
RETURNING PostgreSQL
RETURNS SQL-2023 DB2 Mimer Teradata
REVALIDATE Teradata
REVERT SQL Server
REVOKE SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
RIGHT SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
RIGHTS Teradata
RLIKE MySQL
ROLE DB2 Teradata
ROLLBACK SQL-2023 DB2 Mimer SQL Server Teradata
ROLLFORWARD Teradata
ROLLUP SQL-2023 DB2 Teradata
ROUND_CEILING DB2
ROUND_DOWN DB2
ROUND_FLOOR DB2
ROUND_HALF_DOWN DB2
ROUND_HALF_EVEN DB2
ROUND_HALF_UP DB2
ROUND_UP DB2
ROUTINE Teradata
ROW SQL-2023 DB2 Mimer MySQL Oracle Teradata
ROWCOUNT SQL Server
ROWGUIDCOL SQL Server
ROWID Oracle Teradata
ROWNUM Oracle
ROWS SQL-2023 Mimer MySQL Oracle Teradata
ROWSET DB2
ROW_NUMBER SQL-2023 MySQL Teradata
RPAD SQL-2023
RULE SQL Server
RUN DB2
RUNNING SQL-2023
SAMPLE Teradata
SAMPLEID Teradata
SAVE SQL Server
SAVEPOINT SQL-2023 DB2 Teradata
SCHEMA DB2 MySQL SQL Server Teradata
SCHEMAS MySQL
SCOPE SQL-2023 Teradata
SCRATCHPAD DB2
SCROLL SQL-2023 Mimer Teradata
SEARCH SQL-2023 Teradata
SECOND SQL-2023 DB2 Mimer Teradata
SECONDS DB2
SECOND_MICROSECOND MySQL
SECQTY DB2
SECTION Teradata
SECURITY DB2
SECURITYAUDIT SQL Server
SEEK SQL-2023
SEL Teradata
SELECT SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
SEMANTICKEYPHRASETABLE SQL Server
SEMANTICSIMILARITYDETAILSTABLE SQL Server
SEMANTICSIMILARITYTABLE SQL Server
SENSITIVE SQL-2023 DB2 MySQL
SEPARATOR MySQL
SEQUENCE DB2 Teradata
SESSION Oracle Teradata
SESSION_USER SQL-2023 DB2 Mimer PostgreSQL SQL Server Teradata
SET SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
SETRESRATE Teradata
SETS Teradata
SETSESSRATE Teradata
SETUSER SQL Server
SHARE Oracle
SHOW SQL-2023 MySQL Teradata
SHUTDOWN SQL Server
SIGNAL SQL/PSM-2016 DB2 Mimer MySQL
SIMILAR SQL-2023 PostgreSQL
SIMPLE DB2
SIN SQL-2023 Teradata
SINH SQL-2023 Teradata
SIZE Oracle Teradata
SKEW Teradata
SKIP SQL-2023
SMALLINT SQL-2023 MySQL Oracle Teradata
SOME SQL-2023 DB2 Mimer PostgreSQL SQL Server Teradata
SOUNDEX Teradata
SOURCE DB2
SPACE Teradata
SPATIAL MySQL
SPECIFIC SQL-2023 DB2 Mimer MySQL Teradata
SPECIFICTYPE SQL-2023 Teradata
SPOOL Teradata
SQL SQL-2023 Mimer MySQL Teradata
SQLEXCEPTION SQL-2023 Mimer MySQL Teradata
SQLSTATE SQL-2023 Mimer MySQL Teradata
SQLTEXT Teradata
SQLWARNING SQL-2023 Mimer MySQL Teradata
SQL_BIG_RESULT MySQL
SQL_CALC_FOUND_ROWS MySQL
SQL_SMALL_RESULT MySQL
SQRT SQL-2023 Teradata
SS Teradata
SSL MySQL
STANDARD DB2
START SQL-2023 Mimer Oracle Teradata
STARTING MySQL
STARTUP Teradata
STATE Teradata
STATEMENT DB2 Teradata
STATIC SQL-2023 DB2 Mimer Teradata
STATISTICS SQL Server Teradata
STAY DB2
STDDEV_POP SQL-2023 Teradata
STDDEV_SAMP SQL-2023 Teradata
STEPINFO Teradata
STOGROUP DB2
STORED MySQL
STORES DB2
STRAIGHT_JOIN MySQL
STRING_CS Teradata
STRUCTURE Teradata
STYLE DB2
SUBMULTISET SQL-2023
SUBSCRIBER Teradata
SUBSET SQL-2023
SUBSTR Teradata
SUBSTRING SQL-2023 Teradata
SUBSTRING_REGEX SQL-2023
SUCCEEDS SQL-2023
SUCCESSFUL Oracle
SUM SQL-2023 Teradata
SUMMARY DB2 Teradata
SUSPEND Teradata
SYMMETRIC SQL-2023 Mimer PostgreSQL
SYNONYM DB2 Oracle
SYSDATE DB2 Oracle
SYSTEM SQL-2023 DB2 MySQL
SYSTEM_TIME SQL-2023
SYSTEM_USER SQL-2023 Mimer PostgreSQL SQL Server Teradata
SYSTIMESTAMP DB2
TABLE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
TABLESAMPLE SQL-2023 PostgreSQL SQL Server
TABLESPACE DB2
TAN SQL-2023 Teradata
TANH SQL-2023 Teradata
TBL_CS Teradata
TEMPORARY Teradata
TERMINATE Teradata
TERMINATED MySQL
TEXTSIZE SQL Server
THAN Teradata
THEN SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
THRESHOLD Teradata
TIME SQL-2023 Teradata
TIMESTAMP SQL-2023 Teradata
TIMEZONE_HOUR SQL-2023 Mimer Teradata
TIMEZONE_MINUTE SQL-2023 Mimer Teradata
TINYBLOB MySQL
TINYINT MySQL
TINYTEXT MySQL
TITLE Teradata
TO SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
TOP SQL Server
TRACE Teradata
TRAILING SQL-2023 Mimer MySQL PostgreSQL Teradata
TRAN SQL Server
TRANSACTION SQL Server Teradata
TRANSLATE SQL-2023 Teradata
TRANSLATE_CHK Teradata
TRANSLATE_REGEX SQL-2023
TRANSLATION SQL-2023 Teradata
TREAT SQL-2023 Mimer Teradata
TRIGGER SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
TRIM SQL-2023 Teradata
TRIM_ARRAY SQL-2023
TRUE SQL-2023 Mimer MySQL PostgreSQL Teradata
TRUNCATE SQL-2023 DB2 SQL Server
TRY_CONVERT SQL Server
TSEQUAL SQL Server
TYPE DB2 Teradata
UC Teradata
UESCAPE SQL-2023
UID Oracle
UNDEFINED Teradata
UNDER Teradata
UNDO DB2 MySQL Teradata
UNION SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
UNIQUE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
UNKNOWN SQL-2023 Mimer Teradata
UNLOCK MySQL
UNNEST SQL-2023 Teradata
UNPIVOT SQL Server
UNSIGNED MySQL
UNTIL SQL/PSM-2016 DB2 Mimer Teradata
UPD Teradata
UPDATE SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
UPDATETEXT SQL Server
UPPER SQL-2023 Teradata
UPPERCASE Teradata
USAGE MySQL Teradata
USE MySQL SQL Server
USER SQL-2023 DB2 Mimer Oracle PostgreSQL SQL Server Teradata
USING SQL-2023 DB2 Mimer MySQL PostgreSQL Teradata
UTC_DATE MySQL
UTC_TIME MySQL
UTC_TIMESTAMP MySQL
VALIDATE Oracle
VALIDPROC DB2
VALUE SQL-2023 DB2 Mimer Teradata
VALUES SQL-2023 DB2 Mimer MySQL Oracle SQL Server Teradata
VALUE_OF SQL-2023
VARBINARY SQL-2023 MySQL
VARBYTE Teradata
VARCHAR SQL-2023 MySQL Oracle Teradata
VARCHAR2 Oracle
VARCHARACTER MySQL
VARGRAPHIC Teradata
VARIABLE DB2 Teradata
VARIADIC PostgreSQL
VARIANT DB2
VARYING SQL-2023 Mimer MySQL SQL Server Teradata
VAR_POP SQL-2023 Teradata
VAR_SAMP SQL-2023 Teradata
VCAT DB2
VERBOSE PostgreSQL
VERSIONING SQL-2023 DB2
VIEW DB2 Oracle SQL Server Teradata
VIRTUAL MySQL
VOLATILE DB2 Teradata
VOLUMES DB2
WAIT Teradata
WAITFOR SQL Server
WHEN SQL-2023 DB2 Mimer MySQL PostgreSQL SQL Server Teradata
WHENEVER SQL-2023 DB2 Oracle Teradata
WHERE SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
WHILE SQL/PSM-2016 DB2 Mimer MySQL SQL Server Teradata
WIDTH_BUCKET SQL-2023 Teradata
WINDOW SQL-2023 MySQL PostgreSQL
WITH SQL-2023 DB2 Mimer MySQL Oracle PostgreSQL SQL Server Teradata
WITHIN SQL-2023
WITHIN_GROUP SQL Server
WITHOUT SQL-2023 Mimer Teradata
WLM DB2
WORK Teradata
WRITE MySQL Teradata
WRITETEXT SQL Server
XMLCAST DB2
XMLEXISTS DB2
XMLNAMESPACES DB2
XOR MySQL
YEAR SQL-2023 DB2 Mimer Teradata
YEARS DB2
YEAR_MONTH MySQL
ZEROFILL MySQL
ZEROIFNULL Teradata
ZONE DB2 Teradata

A dash (-) means that the keyword is not reserved.

See also

[edit]

References

[edit]
  1. ^ a b "Appendix C. SQL Key Words". PostgreSQL documentation. The PostgreSQL Global Development Group. Retrieved 31 October 2022.
  2. ^ a b "Reserved Keywords (Transact-SQL)". Microsoft Docs – SQL Server. Microsoft. Retrieved 23 December 2020.
  3. ^ ISO/IEC 9075-2:2023 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) (6th ed.). International Organization for Standardization. June 2023. Retrieved 5 June 2023.
  4. ^ "Reserved words". IBM Knowledge Center. IBM. 11 January 2023. Retrieved 8 June 2023.
  5. ^ "Reserved Words". Mimer SQL Manuals. Mimer AB. Retrieved 23 December 2020.
  6. ^ "Keywords and Reserved Words". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 23 December 2020.
  7. ^ "Oracle SQL Reserved Words". SQL Language Reference. Oracle Corporation. Retrieved 6 June 2023.
  8. ^ "Reserved Words for Teradata". The Teradata Forum. Manta BlueSky. Retrieved 23 December 2020.