List of SQL reserved words
[ temporary import ]
please note:
- the content below is remote from Wikipedia
- it has been imported raw for GetWiki
{{Short description|none}}{{Use dmy dates|date=December 2020}}This list includes
SQL reserved words â aka
SQL reserved keywords,WEB,
www.postgresql.org/docs/16/sql-keywords-appendix.html, Appendix C. SQL Key Words, PostgreSQL documentation, The PostgreSQL Global Development Group, 2022-10-31, WEB,
docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver16, Reserved Keywords (Transact-SQL), Microsoft Docs â SQL Server,
Microsoft, 2020-12-23, as the specifies and some
RDBMSs have added.{| class=“wikitable sortable“|+ Reserved words in SQL and related products
|
! !! In BOOK, ISO/IEC 9075-2:2023 Information technology â Database languages â SQL â Part 2: Foundation (SQL/Foundation), International Organization for Standardization, June 2023, 6th,www.iso.org/standard/76584.html, subscription, 2023-06-05, !! In IBM Db2 13WEB,www.ibm.com/docs/en/db2-for-zos/13?topic=words-reserved, Reserved words, IBM Knowledge Center, 2023-01-11, IBM, 2023-06-08, !! In Mimer SQL 11.0WEB,docs.mimer.com/MimerSqlManual/v110/html/Manuals/App_reserved_words/App_reserved_words.htm, Reserved Words, Mimer SQL Manuals, Mimer AB, 2020-12-23, !! In MySQL 8.0WEB,dev.mysql.com/doc/refman/8.0/en/keywords.html#keywords-in-current-series, Keywords and Reserved Words, MySQL 8.0 Reference Manual, Oracle Corporation, 2020-12-23, !! In Oracle Database 23cWEB,docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/Oracle-SQL-Reserved-Words.html, Oracle SQL Reserved Words, SQL Language Reference, Oracle Corporation, 2023-06-06, !! In PostgreSQL 16 !! In Microsoft SQL Server 2022 !! In Teradata 15WEB,teradataforum.com/l030103a.htm, Reserved Words for Teradata, The Teradata Forum, Manta BlueSky, 2020-12-23,
|
! {{rh}} | ABORT | | | | | | | Teradata |
|
! {{rh}} | ABORTSESSION | | | | | | | Teradata |
|
! {{rh}} | ABS | | | | | | | Teradata |
|
! {{rh}} | ABSENT | | | | | | | {{sdash}} |
|
! {{rh}} | ABSOLUTE | | | | | | | Teradata |
|
! {{rh}} | ACCESS | | | | | | | {{sdash}} |
|
! {{rh}} | ACCESSIBLE | | | | | | | {{sdash}} |
|
! {{rh}} | ACCESS_LOCK | | | | | | | Teradata |
|
! {{rh}} | ACCOUNT | | | | | | | Teradata |
|
! {{rh}} | ACOS | | | | | | | Teradata |
|
! {{rh}} | ACOSH | | | | | | | Teradata |
|
! {{rh}} | ACTION | | | | | | | Teradata |
|
! {{rh}} | ADD | | | | | | | Teradata |
|
! {{rh}} | ADD_MONTHS | | | | | | | Teradata |
|
! {{rh}} | ADMIN | | | | | | | Teradata |
|
! {{rh}} | AFTER | | | | | | | Teradata |
|
! {{rh}} | AGGREGATE | | | | | | | Teradata |
|
! {{rh}} | ALIAS | | | | | | | Teradata |
|
! {{rh}} | ALL | | | | | | | Teradata |
|
! {{rh}} | ALLOCATE | | | | | | | Teradata |
|
! {{rh}} | ALLOW | | | | | | | {{sdash}} |
|
! {{rh}} | ALTER | | | | | | | Teradata |
|
! {{rh}} | ALTERAND | | | | | | | {{sdash}} |
|
! {{rh}} | AMP | | | | | | | Teradata |
|
! {{rh}} | ANALYSE | | | | | | | {{sdash}} |
|
! {{rh}} | ANALYZE | | | | | | | {{sdash}} |
|
! {{rh}} | AND | | | | | | | Teradata |
|
! {{rh}} | ANSIDATE | | | | | | | Teradata |
|
! {{rh}} | ANY | | | | | | | Teradata |
|
! {{rh}} | ANY_VALUE | | | | | | | {{sdash}} |
|
! {{rh}} | ARE | | | | | | | Teradata |
|
! {{rh}} | ARRAY | | | | | | | Teradata |
|
! {{rh}} | ARRAY_AGG | | | | | | | {{sdash}} |
|
! {{rh}} | ARRAY_EXISTS | | | | | | | {{sdash}} |
|
! {{rh}} | ARRAY_MAX_CARDINALITY | | | | | | | {{sdash}} |
|
! {{rh}} | AS | | | | | | | Teradata |
|
! {{rh}} | ASC | | | | | | | Teradata |
|
! {{rh}} | ASENSITIVE | | | | | | | {{sdash}} |
|
! {{rh}} | ASIN | | | | | | | Teradata |
|
! {{rh}} | ASINH | | | | | | | Teradata |
|
! {{rh}} | ASSERTION | | | | | | | Teradata |
|
! {{rh}} | ASSOCIATE | | | | | | | {{sdash}} |
|
! {{rh}} | ASUTIME | | | | | | | {{sdash}} |
|
! {{rh}} | ASYMMETRIC | | | | | | | {{sdash}} |
|
! {{rh}} | AT | | | | | | | Teradata |
|
! {{rh}} | ATAN | | | | | | | Teradata |
|
! {{rh}} | ATAN2 | | | | | | | Teradata |
|
! {{rh}} | ATANH | | | | | | | Teradata |
|
! {{rh}} | ATOMIC | | | | | | | Teradata |
|
! {{rh}} | AUDIT | | | | | | | {{sdash}} |
|
! {{rh}} | AUTHORIZATION | | | | | | | Teradata |
|
! {{rh}} | AUX | | | | | | | {{sdash}} |
|
! {{rh}} | AUXILIARY | | | | | | | {{sdash}} |
|
! {{rh}} | AVE | | | | | | | Teradata |
|
! {{rh}} | AVERAGE | | | | | | | Teradata |
|
! {{rh}} | AVG | | | | | | | Teradata |
|
! {{rh}} | BACKUP | | | | | | | {{sdash}} |
|
! {{rh}} | BEFORE | | | | | | | Teradata |
|
! {{rh}} | BEGIN | | | | | | | Teradata |
|
! {{rh}} | BEGIN_FRAME | | | | | | | {{sdash}} |
|
! {{rh}} | BEGIN_PARTITION | | | | | | | {{sdash}} |
|
! {{rh}} | BETWEEN | | | | | | | Teradata |
|
! {{rh}} | BIGINT | | | | | | | {{sdash}} |
|
! {{rh}} | BINARY | | | | | | | Teradata |
|
! {{rh}} | BIT | | | | | | | Teradata |
|
! {{rh}} | BLOB | | | | | | | Teradata |
|
! {{rh}} | BOOLEAN | | | | | | | Teradata |
|
! {{rh}} | BOTH | | | | | | | Teradata |
|
! {{rh}} | BREADTH | | | | | | | Teradata |
|
! {{rh}} | BREAK | | | | | | | {{sdash}} |
|
! {{rh}} | BROWSE | | | | | | | {{sdash}} |
|
! {{rh}} | BT | | | | | | | Teradata |
|
! {{rh}} | BTRIM | | | | | | | {{sdash}} |
|
! {{rh}} | BUFFERPOOL | | | | | | | {{sdash}} |
|
! {{rh}} | BULK | | | | | | | {{sdash}} |
|
! {{rh}} | BUT | | | | | | | Teradata |
|
! {{rh}} | BY | | | | | | | Teradata |
|
! {{rh}} | BYTE | | | | | | | Teradata |
|
! {{rh}} | BYTEINT | | | | | | | Teradata |
|
! {{rh}} | BYTES | | | | | | | Teradata |
|
! {{rh}} | CALL | | | | | | | Teradata |
|
! {{rh}} | CALLED | | | | | | | {{sdash}} |
|
! {{rh}} | CAPTURE | | | | | | | {{sdash}} |
|
! {{rh}} | CARDINALITY | | | | | | | {{sdash}} |
|
! {{rh}} | CASCADE | | | | | | | Teradata |
|
! {{rh}} | CASCADED | | | | | | | Teradata |
|
! {{rh}} | CASE | | | | | | | Teradata |
|
! {{rh}} | CASESPECIFIC | | | | | | | Teradata |
|
! {{rh}} | CASE_N | | | | | | | Teradata |
|
! {{rh}} | CAST | | | | | | | Teradata |
|
! {{rh}} | CATALOG | | | | | | | Teradata |
|
! {{rh}} | CCSID | | | | | | | {{sdash}} |
|
! {{rh}} | CD | | | | | | | Teradata |
|
! {{rh}} | CEIL | | | | | | | {{sdash}} |
|
! {{rh}} | CEILING | | | | | | | {{sdash}} |
|
! {{rh}} | CHANGE | | | | | | | {{sdash}} |
|
! {{rh}} | CHAR | | | | | | | Teradata |
|
! {{rh}} | CHAR2HEXINT | | | | | | | Teradata |
|
! {{rh}} | CHARACTER | | | | | | | Teradata |
|
! {{rh}} | CHARACTERS | | | | | | | Teradata |
|
! {{rh}} | CHARACTER_LENGTH | | | | | | | Teradata |
|
! {{rh}} | CHARS | | | | | | | Teradata |
|
! {{rh}} | CHAR_LENGTH | | | | | | | Teradata |
|
! {{rh}} | CHECK | | | | | | | Teradata |
|
! {{rh}} | CHECKPOINT | | | | | | | Teradata |
|
! {{rh}} | CLASS | | | | | | | Teradata |
|
! {{rh}} | CLASSIFIER | | | | | | | {{sdash}} |
|
! {{rh}} | CLOB | | | | | | | Teradata |
|
! {{rh}} | CLONE | | | | | | | {{sdash}} |
|
! {{rh}} | CLOSE | | | | | | | Teradata |
|
! {{rh}} | CLUSTER | | | | | | | Teradata |
|
! {{rh}} | CLUSTERED | | | | | | | {{sdash}} |
|
! {{rh}} | CM | | | | | | | Teradata |
|
! {{rh}} | COALESCE | | | | | | | Teradata |
|
! {{rh}} | COLLATE | | | | | | | Teradata |
|
! {{rh}} | COLLATION | | | | | | | Teradata |
|
! {{rh}} | COLLECT | | | | | | | Teradata |
|
! {{rh}} | COLLECTION | | | | | | | {{sdash}} |
|
! {{rh}} | COLLID | | | | | | | {{sdash}} |
|
! {{rh}} | COLUMN | | | | | | | Teradata |
|
! {{rh}} | COLUMN_VALUE | | | | | | | {{sdash}} |
|
! {{rh}} | COMMENT | | | | | | | Teradata |
|
! {{rh}} | COMMIT | | | | | | | Teradata |
|
! {{rh}} | COMPLETION | | | | | | | Teradata |
|
! {{rh}} | COMPRESS | | | | | | | Teradata |
|
! {{rh}} | COMPUTE | | | | | | | {{sdash}} |
|
! {{rh}} | CONCAT | | | | | | | {{sdash}} |
|
! {{rh}} | CONCURRENTLY | | | | | | | {{sdash}} |
|
! {{rh}} | CONDITION | | | | | | | {{sdash}} |
|
! {{rh}} | CONNECT | | | | | | | Teradata |
|
! {{rh}} | CONNECTION | | | | | | | Teradata |
|
! {{rh}} | CONSTRAINT | | | | | | | Teradata |
|
! {{rh}} | CONSTRAINTS | | | | | | | Teradata |
|
! {{rh}} | CONSTRUCTOR | | | | | | | Teradata |
|
! {{rh}} | CONTAINS | | | | | | | {{sdash}} |
|
! {{rh}} | CONTAINSTABLE | | | | | | | {{sdash}} |
|
! {{rh}} | CONTENT | | | | | | | {{sdash}} |
|
! {{rh}} | CONTINUE | | | | | | | Teradata |
|
! {{rh}} | CONVERT | | | | | | | {{sdash}} |
|
! {{rh}} | CONVERT_TABLE_HEADER | | | | | | | Teradata |
|
! {{rh}} | COPY | | | | | | | {{sdash}} |
|
! {{rh}} | CORR | | | | | | | Teradata |
|
! {{rh}} | CORRESPONDING | | | | | | | Teradata |
|
! {{rh}} | COS | | | | | | | Teradata |
|
! {{rh}} | COSH | | | | | | | Teradata |
|
! {{rh}} | COUNT | | | | | | | Teradata |
|
! {{rh}} | COVAR_POP | | | | | | | Teradata |
|
! {{rh}} | COVAR_SAMP | | | | | | | Teradata |
|
! {{rh}} | CREATE | | | | | | | Teradata |
|
! {{rh}} | CROSS | | | | | | | Teradata |
|
! {{rh}} | CS | | | | | | | Teradata |
|
! {{rh}} | CSUM | | | | | | | Teradata |
|
! {{rh}} | CT | | | | | | | Teradata |
|
! {{rh}} | CUBE | | | | | | | Teradata |
|
! {{rh}} | CUME_DIST | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT | | | | | | | Teradata |
|
! {{rh}} | CURRENT_CATALOG | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_DATE | | | | | | | Teradata |
|
! {{rh}} | CURRENT_DEFAULT_TRANSFORM_GROUP | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_LC_CTYPE | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_PATH | | | | | | | Teradata |
|
! {{rh}} | CURRENT_ROLE | | | | | | | Teradata |
|
! {{rh}} | CURRENT_ROW | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_SCHEMA | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_SERVER | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_TIME | | | | | | | Teradata |
|
! {{rh}} | CURRENT_TIMESTAMP | | | | | | | Teradata |
|
! {{rh}} | CURRENT_TIMEZONE | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_TRANSFORM_GROUP_FOR_TYPE | | | | | | | {{sdash}} |
|
! {{rh}} | CURRENT_USER | | | | | | | Teradata |
|
! {{rh}} | CURRVAL | | | | | | | {{sdash}} |
|
! {{rh}} | CURSOR | | | | | | | Teradata |
|
! {{rh}} | CV | | | | | | | Teradata |
|
! {{rh}} | CYCLE | | | | | | | Teradata |
|
! {{rh}} | DATA | | | | | | | Teradata |
|
! {{rh}} | DATABASE | | | | | | | Teradata |
|
! {{rh}} | DATABASES | | | | | | | {{sdash}} |
|
! {{rh}} | DATABLOCKSIZE | | | | | | | Teradata |
|
! {{rh}} | DATE | | | | | | | Teradata |
|
! {{rh}} | DATEFORM | | | | | | | Teradata |
|
! {{rh}} | DAY | | | | | | | Teradata |
|
! {{rh}} | DAYS | | | | | | | {{sdash}} |
|
! {{rh}} | DAY_HOUR | | | | | | | {{sdash}} |
|
! {{rh}} | DAY_MICROSECOND | | | | | | | {{sdash}} |
|
! {{rh}} | DAY_MINUTE | | | | | | | {{sdash}} |
|
! {{rh}} | DAY_SECOND | | | | | | | {{sdash}} |
|
! {{rh}} | DBCC | | | | | | | {{sdash}} |
|
! {{rh}} | DBINFO | | | | | | | {{sdash}} |
|
! {{rh}} | DEALLOCATE | | | | | | | Teradata |
|
! {{rh}} | DEC | | | | | | | Teradata |
|
! {{rh}} | DECFLOAT | | | | | | | {{sdash}} |
|
! {{rh}} | DECIMAL | | | | | | | Teradata |
|
! {{rh}} | DECLARE | | | | | | | Teradata |
|
! {{rh}} | DEFAULT | | | | | | | Teradata |
|
! {{rh}} | DEFERRABLE | | | | | | | Teradata |
|
! {{rh}} | DEFERRED | | | | | | | Teradata |
|
! {{rh}} | DEFINE | | | | | | | {{sdash}} |
|
! {{rh}} | DEGREES | | | | | | | Teradata |
|
! {{rh}} | DEL | | | | | | | Teradata |
|
! {{rh}} | DELAYED | | | | | | | {{sdash}} |
|
! {{rh}} | DELETE | | | | | | | Teradata |
|
! {{rh}} | DENSE_RANK | | | | | | | {{sdash}} |
|
! {{rh}} | DENY | | | | | | | {{sdash}} |
|
! {{rh}} | DEPTH | | | | | | | Teradata |
|
! {{rh}} | DEREF | | | | | | | Teradata |
|
! {{rh}} | DESC | | | | | | | Teradata |
|
! {{rh}} | DESCRIBE | | | | | | | Teradata |
|
! {{rh}} | DESCRIPTOR | | | | | | | Teradata |
|
! {{rh}} | DESTROY | | | | | | | Teradata |
|
! {{rh}} | DESTRUCTOR | | | | | | | Teradata |
|
! {{rh}} | DETERMINISTIC | | | | | | | Teradata |
|
! {{rh}} | DIAGNOSTIC | | | | | | | Teradata |
|
! {{rh}} | DIAGNOSTICS | | | | | | | Teradata |
|
! {{rh}} | DICTIONARY | | | | | | | Teradata |
|
! {{rh}} | DISABLE | | | | | | | {{sdash}} |
|
! {{rh}} | DISABLED | | | | | | | Teradata |
|
! {{rh}} | DISALLOW | | | | | | | {{sdash}} |
|
! {{rh}} | DISCONNECT | | | | | | | Teradata |
|
! {{rh}} | DISK | | | | | | | {{sdash}} |
|
! {{rh}} | DISTINCT | | | | | | | Teradata |
|
! {{rh}} | DISTINCTROW | | | | | | | {{sdash}} |
|
! {{rh}} | DISTRIBUTED | | | | | | | {{sdash}} |
|
! {{rh}} | DIV | | | | | | | {{sdash}} |
|
! {{rh}} | DO | | | | | | | Teradata |
|
! {{rh}} | DOCUMENT | | | | | | | {{sdash}} |
|
! {{rh}} | DOMAIN | | | | | | | Teradata |
|
! {{rh}} | DOUBLE | | | | | | | Teradata |
|
! {{rh}} | DROP | | | | | | | Teradata |
|
! {{rh}} | DSSIZE | | | | | | | {{sdash}} |
|
! {{rh}} | DUAL | | | | | | | Teradata |
|
! {{rh}} | DUMP | | | | | | | Teradata |
|
! {{rh}} | DYNAMIC | | | | | | | Teradata |
|
! {{rh}} | EACH | | | | | | | Teradata |
|
! {{rh}} | ECHO | | | | | | | Teradata |
|
! {{rh}} | EDITPROC | | | | | | | {{sdash}} |
|
! {{rh}} | ELEMENT | | | | | | | {{sdash}} |
|
! {{rh}} | ELSE | | | | | | | Teradata |
|
! {{rh}} | ELSEIF | | | | | | | Teradata |
|
! {{rh}} | EMPTY | | | | | | | {{sdash}} |
|
! {{rh}} | ENABLED | | | | | | | Teradata |
|
! {{rh}} | ENCLOSED | | | | | | | {{sdash}} |
|
! {{rh}} | ENCODING | | | | | | | {{sdash}} |
|
! {{rh}} | ENCRYPTION | | | | | | | {{sdash}} |
|
! {{rh}} | END | | | | | | | Teradata |
|
! {{rh}} | END-EXEC | | | | | | | Teradata |
|
! {{rh}} | ENDING | | | | | | | {{sdash}} |
|
! {{rh}} | END_FRAME | | | | | | | {{sdash}} |