List of SQL reserved words

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

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

See also

References

  1. "Appendix C. SQL Key Words". PostgreSQL documentation. The PostgreSQL Global Development Group. Retrieved 31 October 2022.
  2. "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.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.