SQL reserved words

This list includes SQL reserved words as specified in the SQL:2016 standard, and also some products' reserved words.

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

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

See also

References

  1. ISO/IEC JTC 1/SC 32 (Data management and interchange committee) (December 2016). ISO/IEC 9075-1:2016 Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) (Technical report) (5 ed.). Retrieved 23 December 2020.{{cite techreport}}: CS1 maint: uses authors parameter (link)
  2. "Reserved words". IBM Knowledge Center. IBM. Retrieved 23 December 2020.
  3. "Reserved Words". Mimer SQL Manuals. Mimer AB. Retrieved 23 December 2020.
  4. "Keywords and Reserved Words". MySQL 8.0 Reference Manual. Oracle Corporation. Retrieved 23 December 2020.
  5. "Oracle SQL Reserved Words". SQL Language Reference. Oracle Corporation. Retrieved 23 December 2020.
  6. "Appendix C. SQL Key Words". PostgreSQL Documentation. PostgreSQL Global Development Group. Retrieved 23 December 2020.
  7. "Reserved Keywords (Transact-SQL)". Microsoft Docs – SQL Server. Microsoft. Retrieved 23 December 2020.
  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.