List of SQL reserved words


This list includes SQL reserved wordsaka SQL reserved keywords, as the SQL:2023 specifies and some RDBMSs have added.

KeywordIn SQL:2023In IBM Db2 13In Mimer SQL 11.0In MySQL 8.0In Oracle Database 23cIn PostgreSQL 17In Microsoft SQL Server 2022In Teradata 15
ABORTTeradata
ABORTSESSIONTeradata
ABSSQL-2023Teradata
ABSENTSQL-2023
ABSOLUTETeradata
ACCESSOracle
ACCESSIBLEMySQL
ACCESS_LOCKTeradata
ACCOUNTTeradata
ACOSSQL-2023Teradata
ACOSHTeradata
ACTIONTeradata
ADDDB2MySQLOracleSQL ServerTeradata
ADD_MONTHSTeradata
ADMINTeradata
AFTERDB2Teradata
AGGREGATETeradata
ALIASTeradata
ALLSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
ALLOCATESQL-2023DB2MimerTeradata
ALLOWDB2
ALTERSQL-2023MimerMySQLOracleSQL ServerTeradata
ALTERANDDB2
AMPTeradata
ANALYSEPostgreSQL
ANALYZEMySQLPostgreSQL
ANDSQL-2023MimerMySQLOraclePostgreSQLSQL ServerTeradata
ANSIDATETeradata
ANYSQL-2023DB2MimerOraclePostgreSQLSQL ServerTeradata
ANY_VALUESQL-2023
ARESQL-2023Teradata
ARRAYSQL-2023DB2PostgreSQLTeradata
ARRAY_AGGSQL-2023
ARRAY_EXISTSDB2
ARRAY_MAX_CARDINALITYSQL-2023
ASSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
ASCMySQLOraclePostgreSQLSQL ServerTeradata
ASENSITIVESQL-2023DB2MySQL
ASINSQL-2023Teradata
ASINHTeradata
ASSERTIONTeradata
ASSOCIATEDB2
ASUTIMEDB2
ASYMMETRICSQL-2023MimerPostgreSQL
ATSQL-2023DB2MimerTeradata
ATANSQL-2023Teradata
ATAN2Teradata
ATANHTeradata
ATOMICSQL-2023MimerTeradata
AUDITDB2Oracle
AUTHORIZATIONSQL-2023MimerPostgreSQLSQL ServerTeradata
AUXDB2
AUXILIARYDB2
AVETeradata
AVERAGETeradata
AVGSQL-2023Teradata
BACKUPSQL Server
BEFOREDB2MySQLTeradata
BEGINSQL-2023DB2MimerSQL ServerTeradata
BEGIN_FRAMESQL-2023
BEGIN_PARTITIONSQL-2023
BETWEENSQL-2023DB2MimerMySQLOracleSQL ServerTeradata
BIGINTSQL-2023MySQL
BINARYSQL-2023MySQLPostgreSQLTeradata
BITTeradata
BLOBSQL-2023MySQLTeradata
BOOLEANSQL-2023Teradata
BOTHSQL-2023MimerMySQLPostgreSQLTeradata
BREADTHTeradata
BREAKSQL Server
BROWSESQL Server
BTTeradata
BTRIMSQL-2023
BUFFERPOOLDB2
BULKSQL Server
BUTTeradata
BYSQL-2023DB2MimerMySQLOracleSQL ServerTeradata
BYTETeradata
BYTEINTTeradata
BYTESTeradata
CALLSQL-2023DB2MimerMySQLTeradata
CALLEDSQL-2023Mimer
CAPTUREDB2
CARDINALITYSQL-2023
CASCADEMySQLSQL ServerTeradata
CASCADEDSQL-2023DB2Teradata
CASESQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
CASESPECIFICTeradata
CASE_NTeradata
CASTSQL-2023DB2MimerPostgreSQLTeradata
CATALOGTeradata
CCSIDDB2
CDTeradata
CEILSQL-2023
CEILINGSQL-2023
CHANGEMySQL
CHARSQL-2023DB2MySQLOracleTeradata
CHAR2HEXINTTeradata
CHARACTERSQL-2023DB2MySQLTeradata
CHARACTERSTeradata
CHARACTER_LENGTHSQL-2023Teradata
CHARSTeradata
CHAR_LENGTHSQL-2023Teradata
CHECKSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
CHECKPOINTSQL ServerTeradata
CLASSTeradata
CLASSIFIERSQL-2023
CLOBSQL-2023Teradata
CLONEDB2
CLOSESQL-2023DB2MimerSQL ServerTeradata
CLUSTERDB2OracleTeradata
CLUSTEREDSQL Server
CMTeradata
COALESCESQL-2023SQL ServerTeradata
COLLATESQL-2023MimerMySQLPostgreSQLSQL ServerTeradata
COLLATIONPostgreSQLTeradata
COLLECTSQL-2023Teradata
COLLECTIONDB2
COLLIDDB2
COLUMNSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
COLUMN_VALUEOracle
COMMENTDB2OracleTeradata
COMMITSQL-2023DB2MimerSQL ServerTeradata
COMPLETIONTeradata
COMPRESSOracleTeradata
COMPUTESQL Server
CONCATDB2
CONCURRENTLYPostgreSQL
CONDITIONSQL-2023DB2MimerMySQL
CONNECTSQL-2023DB2MimerOracleTeradata
CONNECTIONDB2Teradata
CONSTRAINTSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
CONSTRAINTSTeradata
CONSTRUCTORTeradata
CONTAINSSQL-2023DB2SQL Server
CONTAINSTABLESQL Server
CONTENTDB2
CONTINUEDB2MySQLSQL ServerTeradata
CONVERTSQL-2023MySQLSQL Server
CONVERT_TABLE_HEADERTeradata
COPYSQL-2023
CORRSQL-2023Teradata
CORRESPONDINGSQL-2023MimerTeradata
COSSQL-2023Teradata
COSHSQL-2023Teradata
COUNTSQL-2023Teradata
COVAR_POPSQL-2023Teradata
COVAR_SAMPSQL-2023Teradata
CREATESQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
CROSSSQL-2023MimerMySQLPostgreSQLSQL ServerTeradata
CSTeradata
CSUMTeradata
CTTeradata
CUBESQL-2023DB2MySQLTeradata
CUME_DISTSQL-2023MySQL
CURRENTSQL-2023DB2MimerOracleSQL ServerTeradata
CURRENT_CATALOGSQL-2023PostgreSQL
CURRENT_DATESQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
CURRENT_DEFAULT_TRANSFORM_GROUPSQL-2023
CURRENT_LC_CTYPEDB2
CURRENT_PATHSQL-2023DB2MimerTeradata
CURRENT_ROLESQL-2023PostgreSQLTeradata
CURRENT_ROWSQL-2023
CURRENT_SCHEMASQL-2023DB2PostgreSQL
CURRENT_SERVERDB2
CURRENT_TIMESQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
CURRENT_TIMESTAMPSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
CURRENT_TIMEZONEDB2
CURRENT_TRANSFORM_GROUP_FOR_TYPESQL-2023
CURRENT_USERSQL-2023MimerMySQLPostgreSQLSQL ServerTeradata
CURRVALDB2
CURSORSQL-2023DB2MimerMySQLSQL ServerTeradata
CVTeradata
CYCLESQL-2023Teradata
DATADB2Teradata
DATABASEDB2MySQLSQL ServerTeradata
DATABASESMySQL
DATABLOCKSIZETeradata
DATESQL-2023OracleTeradata
DATEFORMTeradata
DAYSQL-2023DB2MimerTeradata
DAYSDB2
DAY_HOURMySQL
DAY_MICROSECONDMySQL
DAY_MINUTEMySQL
DAY_SECONDMySQL
DBCCSQL Server
DBINFODB2
DEALLOCATESQL-2023MimerSQL ServerTeradata
DECSQL-2023MySQLTeradata
DECFLOATSQL-2023
DECIMALSQL-2023MySQLOracleTeradata
DECLARESQL-2023DB2MimerMySQLSQL ServerTeradata
DEFAULTSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
DEFERRABLEPostgreSQLTeradata
DEFERREDTeradata
DEFINESQL-2023
DEGREESTeradata
DELTeradata
DELAYEDMySQL
DELETESQL-2023DB2MimerMySQLOracleSQL ServerTeradata
DENSE_RANKSQL-2023MySQL
DENYSQL Server
DEPTHTeradata
DEREFSQL-2023Teradata
DESCMySQLOraclePostgreSQLSQL ServerTeradata
DESCRIBESQL-2023MimerMySQLTeradata
DESCRIPTORDB2Teradata
DESTROYTeradata
DESTRUCTORTeradata
DETERMINISTICSQL-2023DB2MimerMySQLTeradata
DIAGNOSTICTeradata
DIAGNOSTICSTeradata
DICTIONARYTeradata
DISABLEDB2
DISABLEDTeradata
DISALLOWDB2
DISCONNECTSQL-2023MimerTeradata
DISKSQL Server
DISTINCTSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
DISTINCTROWMySQL
DISTRIBUTEDSQL Server
DIVMySQL
DOSQL/PSM-2016DB2MimerPostgreSQLTeradata
DOCUMENTDB2
DOMAINTeradata
DOUBLESQL-2023DB2MySQLSQL ServerTeradata
DROPSQL-2023DB2MimerMySQLOracleSQL ServerTeradata
DSSIZEDB2
DUALMySQLTeradata
DUMPSQL ServerTeradata
DYNAMICSQL-2023DB2Teradata
EACHSQL-2023MySQLTeradata
ECHOTeradata
EDITPROCDB2
ELEMENTSQL-2023
ELSESQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
ELSEIFSQL/PSM-2016DB2MimerMySQLTeradata
EMPTYSQL-2023MySQL
ENABLEDTeradata
ENCLOSEDMySQL
ENCODINGDB2
ENCRYPTIONDB2
ENDSQL-2023DB2MimerPostgreSQLSQL ServerTeradata
END-EXECSQL-2023DB2Teradata
ENDINGDB2
END_FRAMESQL-2023
END_PARTITIONSQL-2023
EQTeradata
EQUALSSQL-2023Teradata
ERASEDB2
ERRLVLSQL Server
ERRORTeradata
ERRORFILESTeradata
ERRORTABLESTeradata
ESCAPESQL-2023DB2MimerSQL ServerTeradata
ESCAPEDMySQL
ETTeradata
EVERYSQL-2023Teradata
EXCEPTSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
EXCEPTIONDB2Teradata
EXCLUSIVEOracle
EXECSQL-2023SQL ServerTeradata
EXECUTESQL-2023DB2MimerSQL ServerTeradata
EXISTSSQL-2023DB2MimerMySQLOracleSQL ServerTeradata
EXITDB2MySQLSQL ServerTeradata
EXPSQL-2023Teradata
EXPLAINDB2MySQLTeradata
EXTERNALSQL-2023DB2MimerSQL ServerTeradata
EXTRACTSQL-2023Teradata
FALLBACKTeradata
FALSESQL-2023MimerMySQLPostgreSQLTeradata
FASTEXPORTTeradata
FENCEDDB2
FETCHSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
FIELDPROCDB2
FILEOracleSQL Server
FILLFACTORSQL Server
FILTERSQL-2023
FINALDB2
FIRSTDB2MimerTeradata
FIRST_VALUESQL-2023MySQL
FLOATSQL-2023MySQLOracleTeradata
FLOAT4MySQL
FLOAT8MySQL
FLOORSQL-2023
FORSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
FORCEMySQL
FOREIGNSQL-2023MimerMySQLPostgreSQLSQL ServerTeradata
FORMATTeradata
FOUNDTeradata
FRAME_ROWSQL-2023
FREESQL-2023DB2Teradata
FREESPACETeradata
FREETEXTSQL Server
FREETEXTTABLESQL Server
FREEZEPostgreSQL
FROMSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
FULLSQL-2023DB2MimerPostgreSQLSQL ServerTeradata
FULLTEXTMySQL
FUNCTIONSQL-2023DB2MimerMySQLSQL ServerTeradata
FUSIONSQL-2023
GETeradata
GENERALTeradata
GENERATEDDB2MySQLTeradata
GETSQL-2023DB2MimerMySQLTeradata
GIVETeradata
GLOBALSQL-2023DB2MimerTeradata
GODB2Teradata
GOTODB2SQL ServerTeradata
GRANTSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
GRAPHICTeradata
GREATESTSQL-2023
GROUPSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
GROUPINGSQL-2023MySQLTeradata
GROUPSSQL-2023MySQL
GTTeradata
HANDLERSQL/PSM-2016DB2MimerTeradata
HASHTeradata
HASHAMPTeradata
HASHBAKAMPTeradata
HASHBUCKETTeradata
HASHROWTeradata
HAVINGSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
HELPTeradata
HIGH_PRIORITYMySQL
HOLDSQL-2023DB2Mimer
HOLDLOCKSQL Server
HOSTTeradata
HOURSQL-2023DB2MimerTeradata
HOURSDB2
HOUR_MICROSECONDMySQL
HOUR_MINUTEMySQL
HOUR_SECONDMySQL
IDENTIFIEDOracle
IDENTITYSQL-2023MimerSQL ServerTeradata
IDENTITYCOLSQL Server
IDENTITY_INSERTSQL Server
IFSQL/PSM-2016DB2MimerMySQLSQL ServerTeradata
IGNOREMySQLTeradata
ILIKEPostgreSQL
IMMEDIATEDB2OracleTeradata
INSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
INCLUSIVEDB2
INCONSISTENTTeradata
INCREMENTOracle
INDEXDB2MySQLOracleSQL ServerTeradata
INDICATORSQL-2023MimerTeradata
INFILEMySQL
INHERITDB2
INITIALSQL-2023Oracle
INITIALIZETeradata
INITIALLYPostgreSQLTeradata
INITIATETeradata
INNERSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
INOUTSQL-2023DB2MimerMySQLTeradata
INPUTTeradata
INSTeradata
INSENSITIVESQL-2023DB2MySQL
INSERTSQL-2023DB2MimerMySQLOracleSQL ServerTeradata
INSTEADTeradata
INTSQL-2023MySQLTeradata
INT1MySQL
INT2MySQL
INT3MySQL
INT4MySQL
INT8MySQL
INTEGERSQL-2023MySQLOracleTeradata
INTEGERDATETeradata
INTERSECTSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
INTERSECTIONSQL-2023
INTERVALSQL-2023MimerMySQLTeradata
INTOSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
IO_AFTER_GTIDSMySQL
IO_BEFORE_GTIDSMySQL
ISSQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
ISNULLPostgreSQL
ISOBIDDB2
ISOLATIONTeradata
ITERATESQL/PSM-2016DB2MimerMySQLTeradata
JARDB2
JOINSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
JOURNALTeradata
JSONSQL-2023
JSON_ARRAYSQL-2023
JSON_ARRAYAGGSQL-2023
JSON_EXISTSSQL-2023
JSON_OBJECTSQL-2023
JSON_OBJECTAGGSQL-2023
JSON_QUERYSQL-2023
JSON_SCALARSQL-2023
JSON_SERIALIZESQL-2023
JSON_TABLESQL-2023MySQL
JSON_TABLE_PRIMITIVESQL-2023
JSON_VALUESQL-2023
KEEPDB2
KEYDB2MySQLSQL ServerTeradata
KEYSMySQL
KILLMySQLSQL Server
KURTOSISTeradata
LABELDB2
LAGSQL-2023MySQL
LANGUAGESQL-2023DB2MimerTeradata
LARGESQL-2023MimerTeradata
LASTDB2Teradata
LAST_VALUESQL-2023MySQL
LATERALSQL-2023MySQLPostgreSQLTeradata
LC_CTYPEDB2
LETeradata
LEADSQL-2023MySQL
LEADINGSQL-2023MimerMySQLPostgreSQLTeradata
LEASTSQL-2023
LEAVESQL/PSM-2016DB2MimerMySQLTeradata
LEFTSQL-2023DB2MimerMySQLPostgreSQLSQL ServerTeradata
LESSTeradata
LEVELOracleTeradata
LIKESQL-2023DB2MimerMySQLOraclePostgreSQLSQL ServerTeradata
LIKE_REGEXSQL-2023
LIMITDB2MySQLPostgreSQLTeradata
LINEARMySQL
LINENOSQL Server
LINESMySQL
LISTAGGSQL-2023
LNSQL-2023Teradata
LOADMySQLSQL Server
LOADINGTeradata
LOCALSQL-2023DB2Mimer