Home Page for the TeradataForum
 

 

Library: White Papers


 

Reserved Words for Teradata

Written by John Hall


The following table lists the Teradata Reserved Words that have been added with Release V2R5.1 (Note: these words were previously reserved by ANSI SQL-99, but were not considered Teradata Reserved Words):

CUBE
GROUPING
ROLLUP
SETS



The following table lists the Teradata Reserved Words that have been added with Release V2R5:

ADMIN   NEXT
AGGREGATE   NONE
   
BLOB   OBJECTS
   ONLY
CASE_N   OPEN
CLASS   
CLOB   PARAMETER
CLOSE   PREPARE
CYCLE   
   PROFILE
DEGREES   PROPORTIONAL
DETERMINISTIC   
   RADIANS
EXTERNAL   RANGE_N
   RETURNS
FETCH   ROW_NUMBER
FIRST   
FUNCTION   SCROLL
   SPECIFIC
GENERATED   SQL
   SQLTEXT
IDENTITY   START
INPUT   STEPINFO
   SUMMARY
LANGUAGE   
LIMIT   THRESHOLD
LOCATOR   TRACE
   
MERGE   WITHOUT



The following table lists all of the the Teradata Reserved Words and the software version in which they were implemented:

Reserved Word Implemented
ABORT V2R3
ABORTSESSION V2R3
ABS V2R3
ABSOLUTE ANSI SQL-99
ACCESS_LOCK V2R3
ACCOUNT V2R3
ACOS V2R4
ACOSH V2R4
ACTION ANSI SQL-99
ADD V2R3 / ANSI SQL-99
ADD_MONTHS V2R3
ADMIN V2R5 / ANSI SQL-99
AFTER V2R3 / ANSI SQL-99
AGGREGATE V2R5
ALIAS V2R3 / ANSI SQL-99
ALL V2R3
ALLOCATE ANSI SQL-99
ALTER V2R3 / ANSI SQL-99
AMP V2R3
AND V2R3 / ANSI SQL-99
ANSIDATE V2R3
ANY V2R3 / ANSI SQL-99
ARE ANSI SQL-99
ARRAY ANSI SQL-99
AS V2R3 / ANSI SQL-99
ASC V2R3 / ANSI SQL-99
ASIN V2R4
ASINH V2R4
ASSERTION ANSI SQL-99
AT V2R3 / ANSI SQL-99
ATAN V2R4
ATAN2 V2R4
ATANH V2R4
ATOMIC V2R3
AUTHORIZATION V2R3 / ANSI SQL-99
AVE V2R3
AVERAGE V2R3
AVG V2R3
  
BEFORE V2R3 / ANSI SQL-99
BEGIN V2R3 / ANSI SQL-99
BETWEEN V2R3
BINARY ANSI SQL-99
BIT ANSI SQL-99
BLOB V2R5 / ANSI SQL-99
BOOLEAN ANSI SQL-99
BOTH V2R3 / ANSI SQL-99
BREADTH ANSI SQL-99
BT V2R3
BUT V2R3
BY V2R3 / ANSI SQL-99
BYTE V2R3
BYTEINT V2R3
BYTES V2R3
  
CALL V2R4 / ANSI SQL-99
CASCADE ANSI SQL-99
CASCADED ANSI SQL-99
CASE V2R3 / ANSI SQL-99
CASE_N V2R5
CASESPECIFIC V2R3
CAST V2R3 / ANSI SQL-99
CATALOG ANSI SQL-99
CD V2R3
CHAR V2R3 / ANSI SQL-99
CHAR_LENGTH V2R3
CHAR2HEXINT V2R3
CHARACTER V2R3 / ANSI SQL-99
CHARACTER_LENGTH V2R3
CHARACTERS V2R3
CHARS V2R3
CHECK V2R3 / ANSI SQL-99
CHECKPOINT V2R3
CLASS V2R5
CLOB V2R5 / ANSI SQL-99
CLOSE V2R5 / ANSI SQL-99
CLUSTER V2R3
CM V2R3
COALESCE V2R3
COLLATE ANSI SQL-99
COLLATION V2R3 / ANSI SQL-99
COLLECT V2R3
COLUMN V2R3 / ANSI SQL-99
COMMENT V2R3
COMMIT V2R3 / ANSI SQL-99
COMPLETION ANSI SQL-99
COMPRESS V2R3
CONNECT ANSI SQL-99
CONNECTION ANSI SQL-99
CONSTRAINT V2R3 / ANSI SQL-99
CONSTRAINTS ANSI SQL-99
CONSTRUCTOR ANSI SQL-99
CONTINUE V2R4 / ANSI SQL-99
CONVERT_TABLE_HEADER V2R3
CORR V2R4
CORRESPONDING ANSI SQL-99
COS V2R4
COSH V2R4
COUNT V2R3
COVAR_POP V2R4
COVAR_SAMP V2R4
CREATE V2R3 / ANSI SQL-99
CROSS V2R3 / ANSI SQL-99
CS V2R3
CSUM V2R3
CT V2R3
CUBE V2R5.1 / ANSI SQL-99
CURRENT V2R3 / ANSI SQL-99
CURRENT_DATE V2R3 / ANSI SQL-99
CURRENT_PATH ANSI SQL-99
CURRENT_ROLE ANSI SQL-99
CURRENT_TIME V2R3 / ANSI SQL-99
CURRENT_TIMESTAMP V2R3 / ANSI SQL-99
CURRENT_USER ANSI SQL-99
CURSOR V2R3 / ANSI SQL-99
CV V2R3
CYCLE V2R5 / ANSI SQL-99
  
DATA ANSI SQL-99
DATABASE V2R3
DATABLOCKSIZE V2R3
DATE V2R3 / ANSI SQL-99
DATEFORM V2R3
DAY V2R3 / ANSI SQL-99
DEALLOCATE ANSI SQL-99
DEC V2R3 / ANSI SQL-99
DECIMAL V2R3 / ANSI SQL-99
DECLARE V2R4 / ANSI SQL-99
DEFAULT V2R3 / ANSI SQL-99
DEFERRABLE ANSI SQL-99
DEFERRED ANSI SQL-99
DEGREES V2R5
DEL V2R3
DELETE V2R3 / ANSI SQL-99
DEPTH ANSI SQL-99
DEREF ANSI SQL-99
DESC V2R3 / ANSI SQL-99
DESCRIBE ANSI SQL-99
DESCRIPTOR V2R3
DESTROY ANSI SQL-99
DESTRUCTOR ANSI SQL-99
DETERMINISTIC V2R5 / ANSI SQL-99
DIAGNOSTIC V2R3
DIAGNOSTICS ANSI SQL-99
DICTIONARY ANSI SQL-99
DISABLED V2R3
DISCONNECT ANSI SQL-99
DISTINCT V2R3 / ANSI SQL-99
DO V2R4
DOMAIN ANSI SQL-99
DOUBLE V2R3 / ANSI SQL-99
DROP V2R3 / ANSI SQL-99
DUAL V2R3
DUMP V2R3
DYNAMIC ANSI SQL-99
  
EACH V2R3 / ANSI SQL-99
ECHO V2R3
ELSE V2R3 / ANSI SQL-99
ELSEIF V2R4
ENABLED V2R3
END V2R3 / ANSI SQL-99
END-EXEC ANSI SQL-99
EQ V2R3
EQUALS ANSI SQL-99
ERROR V2R3
ERRORFILES V2R3
ERRORTABLES V2R3
ESCAPE V2R3 / ANSI SQL-99
ET V2R3
EVERY ANSI SQL-99
EXCEPT V2R3 / ANSI SQL-99
EXCEPTION ANSI SQL-99
EXEC V2R3 / ANSI SQL-99
EXECUTE V2R3 / ANSI SQL-99
EXISTS V2R3
EXIT V2R4
EXP V2R3
EXPLAIN V2R3
EXTERNAL V2R5 / ANSI SQL-99
EXTRACT V2R3
  
FALLBACK V2R3
FALSE ANSI SQL-99
FASTEXPORT V2R3
FETCH V2R5 / ANSI SQL-99
FIRST V2R5 / ANSI SQL-99
FLOAT V2R3 / ANSI SQL-99
FOR V2R3 / ANSI SQL-99
FOREIGN V2R3 / ANSI SQL-99
FORMAT V2R3
FOUND V2R4 / ANSI SQL-99
FREE ANSI SQL-99
FREESPACE V2R3
FROM V2R3 / ANSI SQL-99
FULL V2R3 / ANSI SQL-99
FUNCTION V2R5 / ANSI SQL-99
  
GE V2R3
GENERAL ANSI SQL-99
GENERATED V2R5
GET ANSI SQL-99
GIVE V2R3
GLOBAL ANSI SQL-99
GO V2R3 / ANSI SQL-99
GOTO V2R3 / ANSI SQL-99
GRANT V2R3 / ANSI SQL-99
GRAPHIC V2R3
GROUP V2R3 / ANSI SQL-99
GROUPING V2R5.1 / ANSI SQL-99
GT V2R3
  
HANDLER V2R4
HASH V2R3
HASHAMP V2R3
HASHBAKAMP V2R3
HASHBUCKET V2R3
HASHROW V2R3
HAVING V2R3 / ANSI SQL-99
HELP V2R3
HOST ANSI SQL-99
HOUR V2R3 / ANSI SQL-99
  
IDENTITY V2R5 / ANSI SQL-99
IF V2R4
IGNORE ANSI SQL-99
IMMEDIATE V2R3 / ANSI SQL-99
IN V2R3 / ANSI SQL-99
INCONSISTENT V2R3
INDEX V2R3
INDICATOR V2R3 / ANSI SQL-99
INITIALIZE ANSI SQL-99
INITIALLY ANSI SQL-99
INITIATE V2R3
INNER V2R3 / ANSI SQL-99
INOUT V2R4 / ANSI SQL-99
INPUT V2R5 / ANSI SQL-99
INS V2R3
INSERT V2R3 / ANSI SQL-99
INSTEAD V2R3
INT V2R3 / ANSI SQL-99
INTEGER V2R3 / ANSI SQL-99
INTEGERDATE V2R3
INTERSECT V2R3 / ANSI SQL-99
INTERVAL V2R3 / ANSI SQL-99
INTO V2R3 / ANSI SQL-99
IS V2R3 / ANSI SQL-99
ISOLATION ANSI SQL-99
ITERATE V2R4 / ANSI SQL-99
  
JOIN V2R3 / ANSI SQL-99
JOURNAL V2R3
  
KEY V2R3 / ANSI SQL-99
KURTOSIS V2R4
  
LANGUAGE V2R5 / ANSI SQL-99
LARGE ANSI SQL-99
LAST ANSI SQL-99
LATERAL ANSI SQL-99
LE V2R3
LEADING V2R3 / ANSI SQL-99
LEAVE V2R4
LEFT V2R3 / ANSI SQL-99
LESS ANSI SQL-99
LEVEL ANSI SQL-99
LIKE V2R3 / ANSI SQL-99
LIMIT V2R5 / ANSI SQL-99
LN V2R3
LOADING V2R3
LOCAL V2R3 / ANSI SQL-99
LOCALTIME ANSI SQL-99
LOCALTIMESTAMP ANSI SQL-99
LOCATOR V2R5 / ANSI SQL-99
LOCK V2R3
LOCKING V2R3
LOG V2R3
LOGGING V2R3
LOGON V2R3
LONG V2R3
LOOP V2R4
LOWER V2R3
LT V2R3
  
MACRO V2R3
MAP ANSI SQL-99
MATCH ANSI SQL-99
MAVG V2R3
MAX V2R3
MAXIMUM V2R3
MCHARACTERS V2R3
MDIFF V2R3
MERGE V2R5
MIN V2R3
MINDEX V2R3
MINIMUM V2R3
MINUS V2R3
MINUTE V2R3 / ANSI SQL-99
MLINREG V2R3
MLOAD V2R3
MOD V2R3 / ANSI SQL-99
MODE V2R3
MODIFIES ANSI SQL-99
MODIFY V2R3 / ANSI SQL-99
MODULE ANSI SQL-99
MONITOR V2R3
MONRESOURCE V2R3
MONSESSION V2R3
MONTH V2R3 / ANSI SQL-99
MSUBSTR V2R3
MSUM V2R3
MULTISET V2R3
  
NAMED V2R3
NAMES ANSI SQL-99
NATIONAL ANSI SQL-99
NATURAL V2R3 / ANSI SQL-99
NCHAR ANSI SQL-99
NCLOB ANSI SQL-99
NE V2R3
NEW V2R3 / ANSI SQL-99
NEW_TABLE V2R3
NEXT V2R5 / ANSI SQL-99
NO V2R3 / ANSI SQL-99
NONE V2R5 / ANSI SQL-99
NOT V2R3 / ANSI SQL-99
NOWAIT V2R3
NULL V2R3 / ANSI SQL-99
NULLIF V2R3
NULLIFZERO V2R3
NUMERIC V2R3 / ANSI SQL-99
  
OBJECT ANSI SQL-99
OBJECTS V2R5
OCTET_LENGTH V2R3
OF V2R3 / ANSI SQL-99
OFF V2R3 / ANSI SQL-99
OLD V2R3 / ANSI SQL-99
OLD_TABLE V2R3
ON V2R3 / ANSI SQL-99
ONLY V2R5 / ANSI SQL-99
OPEN V2R5 / ANSI SQL-99
OPERATION ANSI SQL-99
OPTION V2R3 / ANSI SQL-99
OR V2R3 / ANSI SQL-99
ORDER V2R3 / ANSI SQL-99
ORDINALITY ANSI SQL-99
OUT V2R4 / ANSI SQL-99
OUTER V2R3 / ANSI SQL-99
OUTPUT ANSI SQL-99
OVER V2R4
OVERLAPS V2R3
OVERRIDE V2R3
  
PAD ANSI SQL-99
PARAMETER V2R5 / ANSI SQL-99
PARAMETERS ANSI SQL-99
PARTIAL ANSI SQL-99
PASSWORD V2R3
PATH ANSI SQL-99
PERCENT V2R3
PERCENT_RANK V2R4
PERM V2R3
PERMANENT V2R3
POSITION V2R3
POSTFIX ANSI SQL-99
PRECISION V2R3 / ANSI SQL-99
PREFIX ANSI SQL-99
PREORDER ANSI SQL-99
PREPARE V2R5 / ANSI SQL-99
PRESERVE V2R3 / ANSI SQL-99
PRIMARY V2R3 / ANSI SQL-99
PRIOR ANSI SQL-99
PRIVATE V2R3
PRIVILEGES V2R3 / ANSI SQL-99
PROCEDURE V2R4 / ANSI SQL-99
PROFILE V2R5
PROPORTIONAL V2R5
PROTECTION V2R3
PUBLIC V2R3 / ANSI SQL-99
  
QUALIFIED V2R4
QUALIFY V2R3
QUANTILE V2R3
  
RADIANS V2R5
RANDOM V2R4
RANGE_N V2R5
RANK V2R3
READ ANSI SQL-99
READS ANSI SQL-99
REAL V2R3 / ANSI SQL-99
RECURSIVE ANSI SQL-99
REF ANSI SQL-99
REFERENCES V2R3 / ANSI SQL-99
REFERENCING V2R3 / ANSI SQL-99
REGR_AVGX V2R4
REGR_AVGY V2R4
REGR_COUNT V2R4
REGR_INTERCEPT V2R4
REGR_R2 V2R4
REGR_SLOPE V2R4
REGR_SXX V2R4
REGR_SXY V2R4
REGR_SYY V2R4
RELATIVE ANSI SQL-99
RELEASE V2R3
RENAME V2R3
REPEAT V2R4
REPLACE V2R3
REPLICATION V2R3
REPOVERRIDE V2R3
REQUEST V2R3
RESTART V2R3
RESTORE V2R3
RESTRICT ANSI SQL-99
RESULT ANSI SQL-99
RESUME V2R3
RET V2R3
RETRIEVE V2R3
RETURN ANSI SQL-99
RETURNS V2R5 / ANSI SQL-99
REVALIDATE V2R3
REVOKE V2R3 / ANSI SQL-99
RIGHT V2R3 / ANSI SQL-99
RIGHTS V2R3
ROLE V2R3 / ANSI SQL-99
ROLLBACK V2R3 / ANSI SQL-99
ROLLFORWARD V2R3
ROLLUP V2R5.1 / ANSI SQL-99
ROUTINE ANSI SQL-99
ROW V2R3 / ANSI SQL-99
ROW_NUMBER V2R5
ROWID V2R3
ROWS V2R3 / ANSI SQL-99
  
SAMPLE V2R3
SAMPLEID V2R3
SAVEPOINT ANSI SQL-99
SCHEMA ANSI SQL-99
SCOPE ANSI SQL-99
SCROLL V2R5 / ANSI SQL-99
SEARCH ANSI SQL-99
SECOND V2R3 / ANSI SQL-99
SECTION ANSI SQL-99
SEL V2R3
SELECT V2R3 / ANSI SQL-99
SEQUENCE ANSI SQL-99
SESSION V2R3 / ANSI SQL-99
SESSION_USER ANSI SQL-99
SET V2R3 / ANSI SQL-99
SETRESRATE V2R3
SETS V2R5.1 / ANSI SQL-99
SETSESSRATE V2R3
SHOW V2R3
SIN V2R4
SINH V2R4
SIZE ANSI SQL-99
SKEW V2R4
SMALLINT V2R3 / ANSI SQL-99
SOME V2R3 / ANSI SQL-99
SOUNDEX V2R4
SPACE ANSI SQL-99
SPECIFIC V2R5 / ANSI SQL-99
SPECIFICTYPE ANSI SQL-99
SPOOL V2R3
SQL V2R5 / ANSI SQL-99
SQLEXCEPTION V2R4 / ANSI SQL-99
SQLSTATE ANSI SQL-99
SQLTEXT V2R5
SQLWARNING V2R4 / ANSI SQL-99
SQRT V2R3
SS V2R3
START V2R5 / ANSI SQL-99
STARTUP V2R3
STATE ANSI SQL-99
STATEMENT V2R3 / ANSI SQL-99
STATIC ANSI SQL-99
STATISTICS V2R3
STDDEV_POP V2R4
STDDEV_SAMP V2R4
STEPINFO V2R5
STRING_CS V2R3
STRUCTURE ANSI SQL-99
SUBSCRIBER V2R3
SUBSTR V2R3
SUBSTRING V2R3
SUM V2R3
SUMMARY V2R5
SUSPEND V2R3
SYSTEM_USER ANSI SQL-99
  
TABLE V2R3 / ANSI SQL-99
TAN V2R4
TANH V2R4
TBL_CS V2R3
TEMPORARY V2R3 / ANSI SQL-99
TERMINATE V2R3 / ANSI SQL-99
THAN ANSI SQL-99
THEN V2R3 / ANSI SQL-99
THRESHOLD V2R5
TIME V2R3 / ANSI SQL-99
TIMESTAMP V2R3 / ANSI SQL-99
TIMEZONE_HOUR V2R3 / ANSI SQL-99
TIMEZONE_MINUTE V2R3 / ANSI SQL-99
TITLE V2R3
TO V2R3 / ANSI SQL-99
TRACE V2R5
TRAILING V2R3 / ANSI SQL-99
TRANSACTION V2R3 / ANSI SQL-99
TRANSLATE V2R3
TRANSLATE_CHK V2R3
TRANSLATION ANSI SQL-99
TREAT ANSI SQL-99
TRIGGER V2R3 / ANSI SQL-99
TRIM V2R3
TRUE ANSI SQL-99
TYPE V2R3
  
UC V2R3
UNDEFINED V2R3
UNDER ANSI SQL-99
UNDO V2R4
UNION V2R3 / ANSI SQL-99
UNIQUE V2R3 / ANSI SQL-99
UNKNOWN ANSI SQL-99
UNNEST ANSI SQL-99
UNTIL V2R4
UPD V2R3
UPDATE V2R3 / ANSI SQL-99
UPPER V2R3
UPPERCASE V2R3
USAGE ANSI SQL-99
USER V2R3 / ANSI SQL-99
USING V2R3 / ANSI SQL-99
  
VALUE V2R4 / ANSI SQL-99
VALUES V2R3 / ANSI SQL-99
VAR_POP V2R4
VAR_SAMP V2R4
VARBYTE V2R3
VARCHAR V2R3 / ANSI SQL-99
VARGRAPHIC V2R3
VARIABLE ANSI SQL-99
VARYING V2R3 / ANSI SQL-99
VIEW V2R3 / ANSI SQL-99
VOLATILE V2R3
  
WAIT V2R3
WHEN V2R3 / ANSI SQL-99
WHENEVER ANSI SQL-99
WHERE V2R3 / ANSI SQL-99
WHILE V2R4
WIDTH_BUCKET V2R4
WITH V2R3 / ANSI SQL-99
WITHOUT V2R5 / ANSI SQL-99
WORK V2R3 / ANSI SQL-99
WRITE ANSI SQL-99
  
YEAR V2R3 / ANSI SQL-99
  
ZEROIFNULL V2R3
ZONE / ANSI SQL-99 V2R3





 
  Top Home Join Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2014 - All Rights Reserved
Last Modified: 03 Mar 2014
 

Recent Threads

Attachments

Library

White Papers

UDFs

 

Quick Reference

Rules of Conduct

FAQs

Join the Forum

 

Archives

Sample Index

2014  2006
2013  2005
2012  2004
2011  2003
2010  2002
2009  2001
2008  2000
2007  1999