#目的
Teradataの予約語と非予約語、およびTeradata Databaseリリース16.xxで導入されたANSI SQL:2011の予約語と非予約語について理解する。
#制限語の種類
予約語のカテゴリとして以下5種類がある
| カテゴリ | 使用可否 |
|---|---|
| Teradata予約語 | 識別子として使用不可 |
| Teradata予約語（将来的） | 識別子として使用不可 |
| Teradata非予約語 | 識別子として使用可能。将来的に予約キーワードとして使用される可能性があるため、非推奨 |
| ANSI SQL:2011予約語 | 将来的にTeradataがANSI機能を導入した場合にその単語がTeradata予約語になる可能性がある |
| ANSI SQL:2011非予約語 | 将来的にTeradataがANSI機能を導入した場合にその単語がTeradata予約語になる可能性がある |
#コマンド
| 内容 | コマンド | 実行例 |
|---|---|---|
| 制限語の一覧を確認（VIEW） | SELECT * FROM SYSLIB.SQLRestrictedWords order by restricted_word ; | |
| 制限語の一覧を確認（ファンクション） | SELECT * FROM TABLE (SYSLIB.SQLRestrictedWords_TBF()) AS t1; |
#表定義
###SYSLIB.SQLRestrictedWords
| 列名 | 意味 |
|---|---|
| restricted_word | 制限語 |
| category | Teradata制限語のカテゴリ R：予約語 F：予約語（将来的） N：非予約語 |
| ANSI_restricted | ANSI制限語のカテゴリ R：予約語 N：非予約語 T：予約語でも非予約語でも無いが、Teradataの予約語 |
#実行例
SELECT * FROM TABLE (SYSLIB.SQLRestrictedWords_TBF()) AS t1;
restricted_word release_introduced release_dropped category ANSI_restricted
------------------------------ ------------------ --------------- -------- ---------------
ABORT 06.02 ? R T
ABORTSESSION 06.02 ? R T
ABS 06.02 ? R R
ACCESS_LOCK 06.02 ? R T
ACCOUNT 06.02 ? R T
ACOS 06.02 ? R T
ACOSH 06.02 ? R T
ADD 06.02 ? R N
ADD_MONTHS 06.02 ? R T
ADMIN 06.02 ? R N
AFTER 06.02 ? R N
AGGREGATE 06.02 ? R T
ALL 06.02 ? R R
ALTER 06.02 ? R R
AMP 06.02 ? R T
AND 06.02 ? R R
ANSIDATE 06.02 ? R T
ANY 06.02 ? R R
ARGLPAREN 06.02 ? R T
AS 06.02 ? R R
ASC 06.02 ? R N
ASIN 06.02 ? R T
ASINH 06.02 ? R T
AT 06.02 ? R R
ATAN 06.02 ? R T
ATAN2 06.02 ? R T
ATANH 06.02 ? R T
ATOMIC 06.02 ? R R
AUTHORIZATION 06.02 ? R R
AVE 06.02 ? R T
AVERAGE 06.02 ? R T
AVG 06.02 ? R R
BEFORE 06.02 ? R N
BEGIN 06.02 ? R R
BETWEEN 06.02 ? R R
BIGINT 06.02 ? R R
BINARY 06.02 ? R R
BLOB 06.02 ? R R
BOTH 06.02 ? R R
BT 06.02 ? R T
BUT 06.02 ? R T
BY 06.02 ? R R
BYTE 06.02 ? R T
BYTEINT 06.02 ? R T
BYTES 06.02 ? R T
CALL 06.02 ? R R
CASE 06.02 ? R R
CASE_N 06.02 ? R T
CASESPECIFIC 06.02 ? R T
CAST 06.02 ? R R
CD 06.02 ? R T
CHAR 06.02 ? R R
CHAR_LENGTH 06.02 ? R R
CHAR2HEXINT 06.02 ? R T
CHARACTER 06.02 ? R R
CHARACTER_LENGTH 06.02 ? R R
CHARACTERS 06.02 ? R N
CHARS 06.02 ? R T
CHECK 06.02 ? R R
CHECKPOINT 06.02 ? R T
CLASS 06.02 ? R T
CLOB 06.02 ? R R
CLOSE 06.02 ? R R
CLUSTER 06.02 ? R T
CM 06.02 ? R T
COALESCE 06.02 ? R R
COLLATION 06.02 ? R N
COLLECT 06.02 ? R R
COLUMN 06.02 ? R R
COMMENT 06.02 ? R T
COMMIT 06.02 ? R R
COMPRESS 06.02 ? R T
CONNECT 13.00 ? R R
CONSTRAINT 06.02 ? R R
CONSTRUCTOR 06.02 ? R N
CONSUME 06.02 ? R T
CONTAINS 12.00 ? R N
CONTINUE 06.02 ? R N
CONVERT_TABLE_HEADER 06.02 ? R T
CORR 06.02 ? R R
COS 06.02 ? R T
COSH 06.02 ? R T
COUNT 06.02 ? R R
COVAR_POP 06.02 ? R R
COVAR_SAMP 06.02 ? R R
CREATE 06.02 ? R R
CROSS 06.02 ? R R
CS 06.02 ? R T
CSUM 06.02 ? R T
CT 06.02 ? R T
CTCONTROL 13.00 ? R T
CUBE 06.02 ? R R
CURRENT 06.02 ? R R
CURRENT_DATE 06.02 ? R R
CURRENT_ROLE 13.00 ? R R
CURRENT_TIME 06.02 ? R R
CURRENT_TIMESTAMP 06.02 ? R R
CURRENT_USER 13.00 ? R R
CURSOR 06.02 ? R R
CV 06.02 ? R T
CYCLE 06.02 ? R R
DATABASE 06.02 ? R T
DATABLOCKSIZE 06.02 ? R T
DATE 06.02 ? R R
DATEFORM 06.02 ? R T
DAY 06.02 ? R R
DEALLOCATE 12.00 ? R R
DEC 06.02 ? R R
DECIMAL 06.02 ? R R
DECLARE 06.02 ? R R
DEFAULT 06.02 ? R R
DEFERRED 06.02 ? R N
DEGREES 06.02 ? R T
DEL 06.02 ? R T
DELETE 06.02 ? R R
DESC 06.02 ? R N
DETERMINISTIC 06.02 ? R R
DIAGNOSTIC 06.02 ? R T
DISABLED 06.02 ? R T
DISTINCT 06.02 ? R R
DO 06.02 ? R R
DOMAIN 06.02 ? R N
DOUBLE 06.02 ? R R
DROP 06.02 ? R R
DUAL 06.02 ? R T
DUMP 06.02 ? R T
DYNAMIC 12.00 ? R R
EACH 06.02 ? R R
ECHO 06.02 ? R T
ELSE 06.02 ? R R
ELSEIF 06.02 ? R R
ENABLED 06.02 ? R T
END 06.02 ? R R
EQ 06.02 ? R T
EQUALS 06.02 ? R N
ERROR 06.02 ? R T
ERRORFILES 06.02 ? R T
ERRORTABLES 06.02 ? R T
ESCAPE 06.02 ? R R
ET 06.02 ? R T
EXCEPT 06.02 ? R R
EXEC 06.02 ? R R
EXECUTE 06.02 ? R R
EXISTS 06.02 ? R R
EXIT 06.02 ? R N
EXP 06.02 ? R R
EXPAND 13.00 ? R T
EXPANDING 13.00 ? R T
EXPLAIN 06.02 ? R T
EXTERNAL 06.02 ? R R
EXTRACT 06.02 ? R R
FALLBACK 06.02 ? R T
FASTEXPORT 06.02 ? R T
FETCH 06.02 ? R R
FIRST 06.02 ? R N
FLOAT 06.02 ? R R
FOR 06.02 ? R R
FOREIGN 06.02 ? R R
FORMAT 06.02 ? R T
FOUND 06.02 ? R N
FREESPACE 06.02 ? R T
FROM 06.02 ? R R
FULL 06.02 ? R R
FUNCTION 06.02 ? R R
GE 06.02 ? R T
GENERATED 06.02 ? R N
GET 13.00 ? R R
GIVE 06.02 ? R T
GRANT 06.02 ? R R
GRAPHIC 06.02 ? R T
GROUP 06.02 ? R R
GROUPING 06.02 ? R R
GT 06.02 ? R T
HANDLER 06.02 ? R R
HASH 06.02 ? R T
HASHAMP 06.02 ? R T
HASHBAKAMP 06.02 ? R T
HASHBUCKET 06.02 ? R T
HASHROW 06.02 ? R T
HAVING 06.02 ? R R
HELP 06.02 ? R T
HOUR 06.02 ? R R
IDENTITY 06.02 ? R R
IF 06.02 ? R R
IMMEDIATE 06.02 ? R N
IN 06.02 ? R R
INCONSISTENT 06.02 ? R T
INDEX 06.02 ? R T
INITIATE 06.02 ? R T
INNER 06.02 ? R R
INOUT 06.02 ? R R
INPUT 06.02 ? R N
INS 06.02 ? R T
INSERT 06.02 ? R R
INSTANCE 06.02 ? R N
INSTEAD 06.02 ? R N
INT 06.02 ? R R
INTEGER 06.02 ? R R
INTEGERDATE 06.02 ? R T
INTERSECT 06.02 ? R R
INTERVAL 06.02 ? R R
INTO 06.02 ? R R
IS 06.02 ? R R
ITERATE 06.02 ? R R
JAR 12.00 ? R R
JOIN 06.02 ? R R
JOURNAL 06.02 ? R T
KEY 06.02 ? R N
KURTOSIS 06.02 ? R T
LANGUAGE 06.02 ? R R
LARGE 06.02 ? R R
LE 06.02 ? R T
LEADING 06.02 ? R R
LEAVE 06.02 ? R R
LEFT 06.02 ? R R
LIKE 06.02 ? R R
LIMIT 06.02 ? R T
LN 06.02 ? R R
LOADING 06.02 ? R T
LOCAL 06.02 ? R R
LOCATOR 06.02 ? R N
LOCK 06.02 ? R T
LOCKING 06.02 ? R T
LOG 06.02 ? R T
LOGGING 06.02 ? R T
LOGON 06.02 ? R T
LONG 06.02 ? R T
LOOP 06.02 ? R R
LOWER 06.02 ? R R
LT 06.02 ? R T
MACRO 06.02 ? R T
MAP 06.02 ? R N
MAVG 06.02 ? R T
MAX 06.02 ? R R
MAXIMUM 06.02 ? R T
MCHARACTERS 06.02 ? R T
MDIFF 06.02 ? R T
MERGE 06.02 ? R R
METHOD 06.02 ? R R
MIN 06.02 ? R R
MINDEX 06.02 ? R T
MINIMUM 06.02 ? R T
MINUS 06.02 ? R T
MINUTE 06.02 ? R R
MLINREG 06.02 ? R T
MLOAD 06.02 ? R T
MOD 06.02 ? R R
MODE 06.02 ? R T
MODIFIES 12.00 ? R R
MODIFY 06.02 ? R T
MONITOR 06.02 ? R T
MONRESOURCE 06.02 ? R T
MONSESSION 06.02 ? R T
MONTH 06.02 ? R R
MSUBSTR 06.02 ? R T
MSUM 06.02 ? R T
MULTISET 06.02 ? R R
NAMED 06.02 ? R T
NATURAL 06.02 ? R R
NE 06.02 ? R T
NEW 06.02 ? R R
NEW_TABLE 06.02 ? R T
NEXT 06.02 ? R N
NO 06.02 ? R R
NONE 06.02 ? R R
NONTEMPORAL 13.10 ? R T
NORMALIZE 13.10 ? R R
NOT 06.02 ? R R
NOWAIT 06.02 ? R T
NULL 06.02 ? R R
NULLIF 06.02 ? R R
NULLIFZERO 06.02 ? R T
NUMBER 14.00 ? R N
NUMERIC 06.02 ? R R
OBJECT 06.02 ? R N
OBJECTS 06.02 ? R T
OCTET_LENGTH 06.02 ? R R
OF 06.02 ? R R
OFF 06.02 ? R T
OLD 06.02 ? R R
OLD_TABLE 06.02 ? R T
ON 06.02 ? R R
ONLY 06.02 ? R R
OPEN 06.02 ? R R
OPTION 06.02 ? R N
OR 06.02 ? R R
ORDER 06.02 ? R R
ORDERING 06.02 ? R N
OUT 06.02 ? R R
OUTER 06.02 ? R R
OVER 06.02 ? R R
OVERLAPS 06.02 ? R R
OVERRIDE 06.02 ? R T
PARAMETER 06.02 ? R R
PASSWORD 06.02 ? R T
PERCENT 06.02 ? R T
PERCENT_RANK 06.02 ? R R
PERM 06.02 ? R T
PERMANENT 06.02 ? R T
POSITION 06.02 ? R R
PRECISION 06.02 ? R R
PREPARE 06.02 ? R R
PRESERVE 06.02 ? R N
PRIMARY 06.02 ? R R
PRIVILEGES 06.02 ? R N
PROCEDURE 06.02 ? R R
PROFILE 06.02 ? R T
PROTECTION 06.02 ? R T
PUBLIC 06.02 ? R N
QUALIFIED 06.02 ? R T
QUALIFY 06.02 ? R T
QUANTILE 06.02 ? R T
QUEUE 06.02 ? R T
RADIANS 06.02 ? R T
RANDOM 06.02 ? R T
RANGE_N 06.02 ? R T
RANK 06.02 ? R R
READS 12.00 ? R R
REAL 06.02 ? R R
RECURSIVE 06.02 ? R R
REFERENCES 06.02 ? R R
REFERENCING 06.02 ? R R
REGR_AVGX 06.02 ? R R
REGR_AVGY 06.02 ? R R
REGR_COUNT 06.02 ? R R
REGR_INTERCEPT 06.02 ? R R
REGR_R2 06.02 ? R R
REGR_SLOPE 06.02 ? R R
REGR_SXX 06.02 ? R R
REGR_SXY 06.02 ? R R
REGR_SYY 06.02 ? R R
RELATIVE 06.02 ? R N
RELEASE 06.02 ? R R
RENAME 06.02 ? R T
REPEAT 06.02 ? R R
REPLACE 06.02 ? R T
REPLCONTROL 06.02 ? R T
REPLICATION 06.02 ? R T
REQUEST 06.02 ? R T
RESIGNAL 13.00 ? R R
RESTART 06.02 ? R N
RESTORE 06.02 ? R T
RESULT 06.02 ? R R
RESUME 06.02 ? R T
RET 06.02 ? R T
RETRIEVE 06.02 ? R T
RETURN 12.00 ? R R
RETURNS 06.02 ? R R
REVALIDATE 06.02 ? R T
REVOKE 06.02 ? R R
RIGHT 06.02 ? R R
RIGHTS 06.02 ? R T
ROLE 06.02 ? R N
ROLLBACK 06.02 ? R R
ROLLFORWARD 06.02 ? R T
ROLLUP 06.02 ? R R
ROW 06.02 ? R R
ROW_NUMBER 06.02 ? R R
ROWID 06.02 ? R T
ROWS 06.02 ? R R
SAMPLE 06.02 ? R T
SAMPLEID 06.02 ? R T
SCROLL 06.02 ? R R
SECOND 06.02 ? R R
SEL 06.02 ? R T
SELECT 06.02 ? R R
SESSION 06.02 ? R N
SET 06.02 ? R R
SETRESRATE 06.02 ? R T
SETS 06.02 ? R N
SETSESSRATE 06.02 ? R T
SHOW 06.02 ? R T
SIGNAL 13.00 ? R R
SIN 06.02 ? R T
SINH 06.02 ? R T
SKEW 06.02 ? R T
SMALLINT 06.02 ? R R
SOME 06.02 ? R R
SOUNDEX 06.02 ? R T
SPECIFIC 06.02 ? R R
SPOOL 06.02 ? R T
SQL 06.02 ? R R
SQLEXCEPTION 06.02 ? R R
SQLTEXT 06.02 ? R T
SQLWARNING 06.02 ? R R
SQRT 06.02 ? R R
SS 06.02 ? R T
START 06.02 ? R R
STARTUP 06.02 ? R T
STATEMENT 06.02 ? R N
STATISTICS 06.02 ? R T
STDDEV_POP 06.02 ? R R
STDDEV_SAMP 06.02 ? R R
STEPINFO 06.02 ? R T
STRING_CS 06.02 ? R T
SUBSCRIBER 06.02 ? R T
SUBSTR 06.02 ? R T
SUBSTRING 06.02 ? R R
SUM 06.02 ? R R
SUMMARY 06.02 ? R T
SUSPEND 06.02 ? R T
TABLE 06.02 ? R R
TAN 06.02 ? R T
TANH 06.02 ? R T
TBL_CS 06.02 ? R T
TEMPORARY 06.02 ? R N
TERMINATE 06.02 ? R T
THEN 06.02 ? R R
THRESHOLD 06.02 ? R T
TIME 06.02 ? R R
TIMESTAMP 06.02 ? R R
TIMEZONE_HOUR 06.02 ? R R
TIMEZONE_MINUTE 06.02 ? R R
TITLE 06.02 ? R T
TO 06.02 ? R R
TOP 06.02 ? R T
TRACE 06.02 ? R T
TRAILING 06.02 ? R R
TRANSACTION 06.02 ? R N
TRANSACTIONTIME 13.10 ? R T
TRANSFORM 06.02 ? R N
TRANSLATE 06.02 ? R R
TRANSLATE_CHK 06.02 ? R T
TRIGGER 06.02 ? R R
TRIM 06.02 ? R R
TYPE 06.02 ? R N
UC 06.02 ? R T
UDTCASTAS 06.02 ? R T
UDTCASTLPAREN 06.02 ? R T
UDTMETHOD 06.02 ? R T
UDTTYPE 06.02 ? R T
UDTUSAGE 06.02 ? R T
UESCAPE 12.00 ? R R
UNDEFINED 06.02 ? R T
UNDO 06.02 ? R N
UNION 06.02 ? R R
UNIQUE 06.02 ? R R
UNTIL 06.02 ? R R
UNTIL_CHANGED 13.00 ? R T
UNTIL_CLOSED 13.10 ? R T
UPD 06.02 ? R T
UPDATE 06.02 ? R R
UPPER 06.02 ? R R
UPPERCASE 06.02 ? R T
USER 06.02 ? R R
USING 06.02 ? R R
VALIDTIME 13.10 ? R T
VALUE 06.02 ? R R
VALUES 06.02 ? R R
VAR_POP 06.02 ? R R
VAR_SAMP 06.02 ? R R
VARBYTE 06.02 ? R T
VARCHAR 06.02 ? R R
VARGRAPHIC 06.02 ? R T
VARIANT_TYPE 13.00 ? R T
VARYING 06.02 ? R R
VIEW 06.02 ? R N
VOLATILE 06.02 ? R T
WHEN 06.02 ? R R
WHERE 06.02 ? R R
WHILE 06.02 ? R R
WIDTH_BUCKET 06.02 ? R R
WITH 06.02 ? R R
WITHOUT 12.00 ? R R
WORK 06.02 ? R N
XMLPLAN 13.00 ? R T
YEAR 06.02 ? R R
ZEROIFNULL 06.02 ? R T
ZONE 06.02 ? R N
ID2BIGINT 15.00 ? R T
ACCESS 06.02 ? N T
AG 06.02 ? N T
ALLOCATION 06.02 ? N T
ALLOCATE 13.00 ? N R
ALLPARAMS 12.00 ? N T
ALWAYS 06.02 ? N N
ANALYSIS 06.02 ? N T
ANCHOR 13.10 ? N T
APPLNAME 13.00 ? N T
ARCHIVE 12.00 ? N T
ASCII 06.02 ? N T
ASSIGNMENT 06.02 ? N N
ATTR 06.02 ? N T
ATTRIBUTE 06.02 ? N N
ATTRIBUTES 06.02 ? N N
ATTRS 06.02 ? N T
AUTO 14.00 ? N T
C 06.02 ? N N
CALLED 06.02 ? N R
CALLER 12.00 ? N T
CHANGERATE 06.02 ? N T
CHARACTERISTICS 06.02 ? N N
CHARSET_COLL 06.02 ? N T
CHECKSUM 06.02 ? N T
CLASS_ORIGIN 13.00 ? N N
CLIENT 12.00 ? N T
COLUMNS 12.00 ? N T
COLUMNSPERINDEX 06.02 ? N T
COLUMNSPERJOININDEX 06.02 ? N T
COMMAND_FUNCTION 13.00 ? N N
COMMAND_FUNCTION_CODE 13.00 ? N N
COMPARABLE 12.00 13.10 N N
COMPARISON 06.02 ? N T
COMPILE 06.02 ? N T
CONDITION 13.00 ? N R
CONDITION_IDENTIFIER 13.00 ? N N
CONDITION_NUMBER 13.00 ? N N
CONTAINED 15.00 ? N T
COST 13.00 ? N T
COSTS 06.02 ? N T
CPP 06.02 ? N T
CPUTIME 06.02 ? N T
CPUTIMENORM 12.00 ? N T
CREATOR 13.00 ? N T
DATA 06.02 ? N N
DBC 06.02 ? N T
DEBUG 06.02 ? N T
DECOMPRESS 13.10 ? N T
DEFINER 06.02 ? N N
DEMOGRAPHICS 06.02 ? N T
DIAGNOSTICS 13.00 ? N N
DENIALS 06.02 ? N T
DIGITS 06.02 ? N T
DOWN 13.00 ? N T
DR 06.02 ? N T
EBCDIC 06.02 ? N T
ELAPSEDSEC 12.00 ? N T
ELAPSEDTIME 12.00 ? N T
ENCRYPT 06.02 ? N T
ERRORS 12.00 ? N T
EXCEPTION 13.00 ? N T
EXCL 06.02 ? N T
EXCLUSIVE 06.02 ? N T
EXPIRE 06.02 ? N T
FINAL 06.02 ? N N
FOLLOWING 06.02 ? N N
FRIDAY 13.10 ? N T
G 06.02 ? N N
GLOBAL 06.02 ? N R
GLOP 13.00 ? N T
HIGH 06.02 ? N T
HOST 06.02 ? N T
IFP 06.02 ? N T
INCREMENT 06.02 ? N N
INDEXESPERTABLE 06.02 ? N T
INDEXMAINTMODE 06.02 ? N T
INIT 12.00 ? N T
INLINE 13.10 ? N T
INSTANTIABLE 06.02 ? N N
INTERFACE 12.00 13.10 N N
INTERNAL 12.00 ? N T
INVOKER 06.02 ? N N
IOCOUNT 06.02 ? N T
ISOLATION 06.02 ? N N
JAVA 06.02 ? N N
JIS_COLL 06.02 ? N T
K 06.02 ? N N
KANJI1 06.02 ? N T
KANJISJIS 06.02 ? N T
KBYTE 06.02 ? N T
KBYTES 06.02 ? N T
KEEP 06.02 ? N T
KILOBYTES 06.02 ? N T
LAST 06.02 ? N N
LATIN 06.02 ? N T
LDIFF 13.00 ? N T
LEVEL 06.02 ? N N
LOCKEDUSEREXPIRE 06.02 ? N T
LOW 06.02 ? N T
M 06.02 ? N N
MATCHED 06.02 ? N N
MAXCHAR 06.02 ? N T
MAXLOGONATTEMPTS 06.02 ? N T
MAXVALUE 06.02 ? N N
MEDIUM 06.02 ? N T
MEETS 13.00 ? N T
MEMBER 13.00 ? N R
MERGEBLOCKRATIO 13.10 ? N T
MESSAGE_LENGTH 13.00 ? N N
MESSAGE_TEXT 13.00 ? N N
MINCHAR 06.02 ? N T
MINVALUE 06.02 ? N N
MODIFIED 06.02 ? N T
MONDAY 13.10 ? N T
MONTH_BEGIN 13.10 ? N T
MONTH_END 13.10 ? N T
MORE 13.00 ? N N
MULTINATIONAL 06.02 ? N T
NAME 06.02 ? N N
NODDLTEXT 13.00 ? N T
NONOPTCOST 12.00 ? N T
NONOPTINIT 12.00 ? N T
NONSEQUENCED 13.10 ? N T
NUMBER 13.00 14.00 N N
OA 06.02 ? N T
OLD_NEW_TABLE 13.00 ? N T
ONLINE 12.00 ? N T
OPTIONS 12.00 ? N N
ORDERED_ANALYTIC 06.02 ? N T
OVERLAYS 12.00 ? N T
OWNER 13.00 ? N T
P_INTERSECT 13.00 ? N T
P_NORMALIZE 13.00 ? N T
PARAMID 12.00 ? N T
PARTITION 06.02 ? N R
PARTITIONED 06.02 ? N T
PARTITION#L1 12.00 ? N T
PARTITION#L2 12.00 ? N T
PARTITION#L3 12.00 ? N T
PARTITION#L4 12.00 ? N T
PARTITION#L5 12.00 ? N T
PARTITION#L6 12.00 ? N T
PARTITION#L7 12.00 ? N T
PARTITION#L8 12.00 ? N T
PARTITION#L9 12.00 ? N T
PARTITION#L10 12.00 ? N T
PARTITION#L11 12.00 ? N T
PARTITION#L12 12.00 ? N T
PARTITION#L13 12.00 ? N T
PARTITION#L14 12.00 ? N T
PARTITION#L15 12.00 ? N T
PARTITION#L16 14.00 ? N T
PARTITION#L17 14.00 ? N T
PARTITION#L18 14.00 ? N T
PARTITION#L19 14.00 ? N T
PARTITION#L20 14.00 ? N T
PARTITION#L21 14.00 ? N T
PARTITION#L22 14.00 ? N T
PARTITION#L23 14.00 ? N T
PARTITION#L24 14.00 ? N T
PARTITION#L25 14.00 ? N T
PARTITION#L26 14.00 ? N T
PARTITION#L27 14.00 ? N T
PARTITION#L28 14.00 ? N T
PARTITION#L29 14.00 ? N T
PARTITION#L30 14.00 ? N T
PARTITION#L31 14.00 ? N T
PARTITION#L32 14.00 ? N T
PARTITION#L33 14.00 ? N T
PARTITION#L34 14.00 ? N T
PARTITION#L35 14.00 ? N T
PARTITION#L36 14.00 ? N T
PARTITION#L37 14.00 ? N T
PARTITION#L38 14.00 ? N T
PARTITION#L39 14.00 ? N T
PARTITION#L40 14.00 ? N T
PARTITION#L41 14.00 ? N T
PARTITION#L42 14.00 ? N T
PARTITION#L43 14.00 ? N T
PARTITION#L44 14.00 ? N T
PARTITION#L45 14.00 ? N T
PARTITION#L46 14.00 ? N T
PARTITION#L47 14.00 ? N T
PARTITION#L48 14.00 ? N T
PARTITION#L49 14.00 ? N T
PARTITION#L50 14.00 ? N T
PARTITION#L51 14.00 ? N T
PARTITION#L52 14.00 ? N T
PARTITION#L53 14.00 ? N T
PARTITION#L54 14.00 ? N T
PARTITION#L55 14.00 ? N T
PARTITION#L56 14.00 ? N T
PARTITION#L57 14.00 ? N T
PARTITION#L58 14.00 ? N T
PARTITION#L59 14.00 ? N T
PARTITION#L60 14.00 ? N T
PARTITION#L61 14.00 ? N T
PARTITION#L62 14.00 ? N T
PERIOD 13.00 ? N T
PORTION 15.00 ? N T
PRECEDES 13.00 ? N T
PRECEDING 06.02 ? N N
PRINT 06.02 ? N T
PRIOR 13.00 ? N N
PROTECTED 06.02 ? N T
QUERY 06.02 ? N T
QUERY_BAND 12.00 ? N T
RANDOMIZED 06.02 ? N T
RANGE 06.02 ? N R
RANGE#L1 12.00 ? N T
RANGE#L2 12.00 ? N T
RANGE#L3 12.00 ? N T
RANGE#L4 12.00 ? N T
RANGE#L5 12.00 ? N T
RANGE#L6 12.00 ? N T
RANGE#L7 12.00 ? N T
RANGE#L8 12.00 ? N T
RANGE#L9 12.00 ? N T
RANGE#L10 12.00 ? N T
RANGE#L11 12.00 ? N T
RANGE#L12 12.00 ? N T
RANGE#L13 12.00 ? N T
RANGE#L14 12.00 ? N T
RANGE#L15 12.00 ? N T
RANGE#L16 14.00 ? N T
RANGE#L17 14.00 ? N T
RANGE#L18 14.00 ? N T
RANGE#L19 14.00 ? N T
RANGE#L20 14.00 ? N T
RANGE#L21 14.00 ? N T
RANGE#L22 14.00 ? N T
RANGE#L23 14.00 ? N T
RANGE#L24 14.00 ? N T
RANGE#L25 14.00 ? N T
RANGE#L26 14.00 ? N T
RANGE#L27 14.00 ? N T
RANGE#L28 14.00 ? N T
RANGE#L29 14.00 ? N T
RANGE#L30 14.00 ? N T
RANGE#L31 14.00 ? N T
RANGE#L32 14.00 ? N T
RANGE#L33 14.00 ? N T
RANGE#L34 14.00 ? N T
RANGE#L35 14.00 ? N T
RANGE#L36 14.00 ? N T
RANGE#L37 14.00 ? N T
RANGE#L38 14.00 ? N T
RANGE#L39 14.00 ? N T
RANGE#L40 14.00 ? N T
RANGE#L41 14.00 ? N T
RANGE#L42 14.00 ? N T
RANGE#L43 14.00 ? N T
RANGE#L44 14.00 ? N T
RANGE#L45 14.00 ? N T
RANGE#L46 14.00 ? N T
RANGE#L47 14.00 ? N T
RANGE#L48 14.00 ? N T
RANGE#L49 14.00 ? N T
RANGE#L50 14.00 ? N T
RANGE#L51 14.00 ? N T
RANGE#L52 14.00 ? N T
RANGE#L53 14.00 ? N T
RANGE#L54 14.00 ? N T
RANGE#L55 14.00 ? N T
RANGE#L56 14.00 ? N T
RANGE#L57 14.00 ? N T
RANGE#L58 14.00 ? N T
RANGE#L59 14.00 ? N T
RANGE#L60 14.00 ? N T
RANGE#L61 14.00 ? N T
RANGE#L62 14.00 ? N T
RDIFF 13.00 ? N T
READ 06.02 ? N N
RECALC 06.02 ? N T
REPLACEMENT 06.02 ? N T
RESET 13.00 ? N T
RESTRICTWORDS 12.00 ? N T
RETAIN 06.02 ? N T
RETURNED_SQLSTATE 13.00 ? N N
REUSE 06.02 ? N T
ROW_COUNT 13.00 ? N N
RU 06.02 ? N T
RULES 13.00 ? N T
RULESET 13.00 ? N T
SAMPLES 06.02 ? N T
SATURDAY 13.10 ? N T
SEARCHSPACE 06.02 ? N T
SECURITY 06.02 ? N N
SEED 06.02 ? N T
SELF 06.02 ? N N
SERIALIZABLE 06.02 ? N N
SEQUENCED 13.10 ? N T
SHARE 06.02 ? N T
SOURCE 06.02 ? N N
SPECCHAR 06.02 ? N T
SPL 06.02 ? N T
SQLDATA 12.00 13.10 N N
SQLSTATE 06.02 ? N R
SR 06.02 ? N T
SYSTEM_TIME 15.00 ? N T
STAT 06.02 ? N T
STATS 06.02 ? N T
STYLE 06.02 ? N N
SUBCLASS_ORIGIN 13.00 ? N N
SUCCEEDS 13.00 ? N T
SUMMARYONLY 06.02 ? N T
SUNDAY 13.10 ? N T
SYSTEM 06.02 ? N R
SYSTEMTEST 06.02 ? N T
TARGET 06.02 ? N T
TD_GENERAL 06.02 ? N T
TD_INTERNAL 06.02 ? N T
TEMPORAL_DATE 13.10 ? N T
TEMPORAL_TIMESTAMP 13.10 ? N T
TEXT 06.02 ? N T
THROUGH 13.00 ? N T
THURSDAY 13.10 ? N T
TIES 06.02 ? N N
TPA 06.02 ? N T
TRANSACTION_ACTIVE 13.00 ? N N
TRUST_ONLY 13.10 ? N T
TUESDAY 13.10 ? N T
UNBOUNDED 06.02 ? N N
UNCOMMITTED 06.02 ? N N
UNICODE 06.02 ? N T
UNKNOWN 06.02 ? N R
USE 06.02 ? N T
VERSIONING 15.00 ? N T
WARNING 06.02 ? N T
WEDNESDAY 13.10 ? N T
WORKLOAD 13.10 ? N T
WRITE 06.02 ? N N
XML 13.00 ? N R
YEAR_BEGIN 14.00 ? N T
YEAR_END 14.00 ? N T
WEEK_BEGIN 14.00 ? N T
WEEK_END 14.00 ? N T
QUARTER_BEGIN 14.00 ? N T
QUARTER_END 14.00 ? N T
CALENDAR 14.00 ? N T
ANCHOR_HOUR 14.00 ? N T
ANCHOR_MINUTE 14.00 ? N T
ANCHOR_SECOND 14.00 ? N T
ANCHOR_MILLISECOND 14.00 ? N T
ARRAY 14.00 ? N R
VARRAY 14.00 ? N T
ORDINALITY 14.00 ? N N
CUME_DIST 14.10 ? N R
DENSE_RANK 14.10 ? N R
NULLS 14.10 ? N N
DENSE 14.10 ? N T
FIRST_VALUE 14.10 ? N T
IGNORE 14.10 ? N T
LAST_VALUE 14.10 ? N T
RESPECT 14.10 ? N T
MEDIAN 14.10 ? N T
PERCENTILE_CONT 14.10 ? N R
PERCENTILE_DISC 14.10 ? N R
WITHIN 14.10 ? N R
TD_VALIST 14.10 ? R T
ALLDBQL 14.10 ? N T
ALLTDWM 14.10 ? N T
TDWMHISTORY 14.10 ? N T
TDWMEXCEPTION 14.10 ? N T
TDWMEVENT 14.10 ? N T
VERBOSE 14.10 ? N T
DETAILED 14.10 ? N T
CAPTURE 14.10 ? N T
STATSUSAGE 14.00 ? N T
USECOUNT 14.10 ? N T
FLUSH 14.10 ? R T
XMLQUERY 14.10 ? N R
XMLTABLE 14.10 ? N R
XMLCOMMENT 14.10 ? N R
XMLPI 14.10 ? N R
XMLDOCUMENT 14.10 ? N R
XMLTEXT 14.10 ? N R
XMLCONCAT 14.10 ? N R
XMLPARSE 14.10 ? N R
XMLSERIALIZE 14.10 ? N R
XMLELEMENT 14.10 ? N R
XMLFOREST 14.10 ? N R
XMLVALIDATE 14.10 ? N R
XMLAGG 14.10 ? N R
XMLNAMESPACES 14.10 ? N R
XMLATTRIBUTES 14.10 ? N R
ELEMENT 14.10 ? N R
STATIC 14.10 ? N R
ACCORDING 14.10 ? N N
BOM 14.10 ? N N
CONTENT 14.10 ? N N
DOCUMENT 14.10 ? N N
ENCODING 14.10 ? N N
INDENT 14.10 ? N N
NAMESPACE 14.10 ? N N
NIL 14.10 ? N N
PASSING 14.10 ? N N
RETURNING 14.10 ? N N
SEQUENCE 14.10 ? N N
STRIP 14.10 ? N N
VERSION 14.10 ? N N
WHITESPACE 14.10 ? N N
XMLDECLARATION 14.10 ? N N
XMLSCHEMA 14.10 ? N N
INCLUDING 14.10 ? N N
EXCLUDING 14.10 ? N N
SIZE 14.10 ? N N
EMPTY 14.10 ? N N
ABSENT 14.10 ? N T
XMLTYPE 14.10 ? N T
TTGRANULARITY 14.10 ? N T
THRESHOLDPERCENT 14.00 ? N T
ORDERBYVALUES 14.00 ? N T
ALIAS 06.02 ? F T
DESCRIPTOR 06.02 ? F N
GO 06.02 ? F N
GOTO 06.02 ? F N
INDICATOR 06.02 ? F R
PRIVATE 06.02 ? F T
WAIT 06.02 ? F T
AbortSessions 12.00 ? N T
AggGeomIntersection 13.10 ? N T
AggGeomUnion 13.10 ? N T
BITAND 13.10 ? N T
BITNOT 13.10 ? N T
BITOR 13.10 ? N T
BITXOR 13.10 ? N T
camset 13.10 ? N T
camset_l 13.10 ? N T
CEIL 13.10 ? N T
CEILING 13.10 ? N T
COUNTSET 13.10 ? N T
day_of_calendar 13.10 ? N T
day_of_month 13.10 ? N T
day_of_week 13.10 ? N T
day_of_year 13.10 ? N T
decamset 13.10 ? N T
decamset_l 13.10 ? N T
FLOOR 13.10 ? N T
GETBIT 13.10 ? N T
GetQueryBand 12.00 ? N T
GetQueryBandValue 12.00 ? N T
GetTimeZoneDisplacement 13.10 ? N T
IdentifyDatabase 12.00 ? N T
IdentifySession 12.00 ? N T
IdentifyTable 12.00 ? N T
IdentifyUser 12.00 ? N T
lzcomp 13.10 ? N T
lzcomp_L 13.10 ? N T
lzdecomp 13.10 ? N T
lzdecomp_L 13.10 ? N T
MonitorQueryBand 12.00 ? N T
MonitorSessionRate 12.00 ? N T
MonitorVersion 12.00 ? N T
month_of_calendar 13.10 ? N T
month_of_quarter 13.10 ? N T
month_of_year 13.10 ? N T
quarter_of_calendar 13.10 ? N T
quarter_of_year 13.10 ? N T
ROTATELEFT 13.10 ? N T
ROTATERIGHT 13.10 ? N T
SETBIT 13.10 ? N T
SetResourceRate 12.00 ? N T
SetSessionAccount 12.00 ? N T
SetSessionRate 12.00 ? N T
SHIFTLEFT 13.10 ? N T
SHIFTRIGHT 13.10 ? N T
SUBBITSTR 13.10 ? N T
TO_BYTE 13.10 ? N T
TransUnicodeToUTF8 13.10 ? N T
TransUTF8ToUnicode 13.10 ? N T
week_of_calendar 13.10 ? N T
week_of_month 13.10 ? N T
week_of_year 13.10 ? N T
weekday_of_month 13.10 ? N T
year_of_calendar 13.10 ? N T
ARRAY_ADD 13.10 ? N T
ARRAY_AGG 13.10 ? N T
ARRAY_AVG 13.10 ? N T
ARRAY_COMPARE 13.10 ? N T
ARRAY_CONCAT 13.10 ? N T
ARRAY_COUNT_DISTINCT 13.10 ? N T
ARRAY_DIV 13.10 ? N T
ARRAY_EQ 13.10 ? N T
ARRAY_GE 13.10 ? N T
ARRAY_GET 13.10 ? N T
ARRAY_GT 13.10 ? N T
ARRAY_LE 13.10 ? N T
ARRAY_LT 13.10 ? N T
ARRAY_MAX 13.10 ? N T
ARRAY_MIN 13.10 ? N T
ARRAY_MOD 13.10 ? N T
ARRAY_MUL 13.10 ? N T
ARRAY_NE 13.10 ? N T
ARRAY_SUB 13.10 ? N T
ARRAY_SUM 13.10 ? N T
ARRAY_UPDATE 13.10 ? N T
ARRAY_UPDATE_STRIDE 13.10 ? N T
CARDINALITY 13.10 ? N T
CHR 13.10 ? N T
DayNumber_Of_Calendar 13.10 ? N T
DayNumber_Of_Month 13.10 ? N T
DayNumber_Of_Week 13.10 ? N T
DayNumber_Of_Year 13.10 ? N T
DayOccurrence_Of_Month 13.10 ? N T
DECODE 13.10 ? N T
EDITDISTANCE 13.10 ? N T
EMPTY_BLOB 13.10 ? N T
EMPTY_CLOB 13.10 ? N T
FROM_BYTES 13.10 ? N T
GetPSFVersion 13.10 ? N T
Greatest 13.10 ? N T
INITCAP 13.10 ? N T
INSTR 13.10 ? N T
Last_Day 13.10 ? N T
Least 13.10 ? N T
LENGTH 13.10 ? N T
LPAD 13.10 ? N T
LTRIM 13.10 ? N T
MonthNumber_Of_Calendar 13.10 ? N T
MonthNumber_Of_Quarter 13.10 ? N T
MonthNumber_Of_Year 13.10 ? N T
Months_Between 13.10 ? N T
NEXT_DAY 13.10 ? N T
NGRAM 13.10 ? N T
NUMFPFNS 13.10 ? N T
NUMTODSINTERVAL 13.10 ? N T
NUMTOYMINTERVAL 13.10 ? N T
nvl 13.10 ? N T
nvl2 13.10 ? N T
NVP 13.10 ? N T
OAdd_Months 13.10 ? N T
OCOUNT 13.10 ? N T
ODELETE 13.10 ? N T
OEXISTS 13.10 ? N T
OEXTEND 13.10 ? N T
OFIRST 13.10 ? N T
OLAST 13.10 ? N T
OLIMIT 13.10 ? N T
ONEXT 13.10 ? N T
OPRIOR 13.10 ? N T
OREPLACE 13.10 ? N T
OTRANSLATE 13.10 ? N T
OTRIM 13.10 ? N T
POWER 13.10 ? N T
QuarterNumber_Of_Calendar 13.10 ? N T
QuarterNumber_Of_Year 13.10 ? N T
regexp_instr 13.10 ? N T
regexp_replace 13.10 ? N T
regexp_similar 13.10 ? N T
regexp_substr 13.10 ? N T
Round 13.10 ? N T
RPAD 13.10 ? N T
RTRIM 13.10 ? N T
SIGN 13.10 ? N T
STRTOK 13.10 ? N T
TD_ARRAY2P 13.10 ? N T
td_day_of_calendar 13.10 ? N T
td_day_of_month 13.10 ? N T
td_day_of_week 13.10 ? N T
td_day_of_year 13.10 ? N T
TD_LZ_COMPRESS 13.10 ? N T
TD_LZ_DECOMPRESS 13.10 ? N T
td_month_of_calendar 13.10 ? N T
td_month_of_quarter 13.10 ? N T
td_month_of_year 13.10 ? N T
td_quarter_of_calendar 13.10 ? N T
td_quarter_of_year 13.10 ? N T
td_weekday_of_month 13.10 ? N T
td_week_of_calendar 13.10 ? N T
td_week_of_month 13.10 ? N T
td_week_of_year 13.10 ? N T
td_year_of_calendar 13.10 ? N T
TO_BYTES 13.10 ? N T
TO_CHAR 13.10 ? N T
TO_DATE 13.10 ? N T
TO_DSINTERVAL 13.10 ? N T
TO_NUMBER 13.10 ? N T
TO_TIMESTAMP 13.10 ? N T
TO_TIMESTAMP_TZ 13.10 ? N T
TO_YMINTERVAL 13.10 ? N T
Trunc 13.10 ? N T
WeekNumber_Of_Calendar 13.10 ? N T
WeekNumber_Of_Month 13.10 ? N T
WeekNumber_Of_Quarter 13.10 ? N T
WeekNumber_Of_Year 13.10 ? N T
YearNumber_Of_Calendar 13.10 ? N T
TD_ANYTYPE 14.00 ? R T
ROWIDGEN 14.00 ? N T
ROWIDGEN2 14.00 ? N T
IPARTITION 14.00 ? N T
MAXINTERVALS 14.00 ? N T
MAXVALUELENGTH 14.00 ? N T
IMMEDIATELY 14.10 ? N T
AUTOTEMP 14.0 ? N T
BLOCKCOMPRESSION 14.0 ? N T
EXPORTWIDTH 14.0 ? N T
MANUAL 14.0 ? N T
NEVER 14.0 ? N T
FORTOKEN 15.00 ? N T
TOTOKEN 15.00 ? N T
CONTAINEDTOKEN 15.00 ? N T
PATH_GENERATOR 15.00 ? N T
PATH_START 15.00 ? N T
PATH_SUMMARIZER 15.00 ? N T
ATTRIBUTION 15.00 ? N T
NPATH 15.00 ? N T
SYMBOLS 15.00 ? N T
SCRIPT 15.00 ? N T
SEQ 15.00 ? N T
DELIMITER 15.00 ? N T
CNT 15.00 ? N T
PARENT 15.00 ? N T
PARTITIONNAMES 15.00 ? N T
NODE 15.00 ? N T
PREFIX 15.00 ? N T
EVENTCOLUMN 15.00 ? N T
TIMESTAMPCOLUMN 15.00 ? N T
WINDOWSIZE 15.00 ? N R
PATTERN 15.00 ? N T
SCRIPT_COMMAND 15.00 ? N T
CHARSET 15.00 ? N T
MAX_CHOOSE 15.00 ? N T
MIN_CHOOSE 15.00 ? N T
FIRST_NOTNULL 15.00 ? N T
LAST_NOTNULL 15.00 ? N T
DUPCOUNT 15.00 ? N T
DUPCOUNTCUM 15.00 ? N T
ACCUMULATE 15.00 ? N T
TRUE 15.00 ? N R
FALSE 15.00 ? N R
SEARCHUIFDBPATH 15.00 ? N T
FILE 15.00 ? N T
SESSIONIZE 15.00 ? N T
TIMECOLUMN 15.00 ? N T
TIMEOUT 15.00 ? N T
RAPIDFIRE 15.00 ? N T
CLICKLAG 15.10 ? N T
EMITNULL 15.00 ? N T
DIMENSION 15.00 ? N T
JSON 15.00 ? N T
JSON_AGG 15.00 ? N T
JSON_COMPOSE 15.00 ? N T
UTILITYINFO 15.00 ? N T
PARAMINFO 15.00 ? N T
CONCURRENT 15.00 ? N T
LOAD 15.00 ? N T
ISOLATED 15.00 ? N T
TD_ROWLOADID 15.00 ? R T
QUOTECHAR 15.00 ? N T
SERVER 15.00 ? N T
IMPORT 15.00 ? N T
EXPORT 15.00 ? N T
ROOT 15.00 ? N T
DBA 15.10 ? N T
TD_HOST 15.10 ? R T
ENCODE 15.10 ? N T
BSON 15.10 ? N T
UBJSON 15.10 ? N T
RETAIN 15.10 ? N T
STORAGE 15.10 ? N T
FOREIGNFUNCTION 15.10 ? N T
FUNCTIONPARAMETER 15.10 ? N T
SCHEMA 15.10 ? N N
PIVOT 16.00 ? N T
UNPIVOT 16.00 ? N T
INCLUDE 16.00 ? N T
EXCLUDE 16.00 ? N T
SCHEMA 15.10 ? N R
COLOCATE 16.00 ? N T
AMPCOUNT 16.00 ? N T
SPARSE 16.00 ? N T
CONTIGUOUS 16.00 ? N T
PASS 16.00 ? N T
NORIGHT 15.10 ? N T
ERRORTBL 16.00 ? N T
ALWAYS 16.00 ? N T
ZLIB 16.00 ? N T
ELZS_H 16.00 ? N T
BLOCKCOMPRESSIONALGORITHM 16.00 ? N T
BLOCKCOMPRESSIONLEVEL 16.00 ? N T
TD_AUTHID 16.00 ? R T
TD_DATASET 16.00 ? N T
DOT 16.00 ? N T
NOTATION 16.00 ? N T
LIST 16.00 ? N T
AVRO 16.00 ? N T
CREATEDATASET 16.00 ? N T
DATASET 16.00 ? N T
SNAPPY_COMPRESS 16.00 ? N T
SNAPPY_DECOMPRESS 16.00 ? N T
ST_GEOMETRY 16.00 ? N T
AUTH 16.00 ? N T
FEATUREINFO 16.00 ? N T
COLUMNMETA 16.00 ? N T
LEAD 16.10 ? N T
LAG 16.10 ? N T
BOTTOM 16.20 ? N T
DELTA_T 16.20 ? N T
DESCRIBE 16.20 ? N R
FILL 16.20 ? N T
PERCENTILE 16.20 ? N T
TIMECODE 16.20 ? N T
TD_GETTIMEBUCKET 16.20 ? N T
MAD 16.20 ? N T
TD_TIME_BUCKET_NUMBER 16.20 ? N T
BIT_LENGTH 16.50 ? N T
LOCATE 16.50 ? N T
UCASE 16.50 ? N T
CURTIME 16.50 ? N T
CURDATE 16.50 ? N T
NOW 16.50 ? N T
CONCAT 16.50 ? N T
MAPPING 16.50 ? N T
NTH 16.50 ? N T
FILTER 16.50 ? N T
#参考
制限語 • Teradata Vantage NewSQLエンジンのリリース サマリー • リーダー • Teradataドキュメント
Restricted Words • Teradata Database SQL Fundamentals • リーダー • Teradataドキュメント