예약어¶
아래는 CUBRID 키워드(keywords) 중 명령어, 함수명, 타입명 등으로 예약되어 있는 예약어(reserved words)를 정리한 표이다. 사용자는 테이블 이름, 칼럼 이름, 변수 이름과 같은 식별자(identifier)로 아래에 정리된 예약어를 사용할 수 없다. 단, 큰따옴표(” “)나 대괄호([ ]) 또는 백틱 부호(` `)로 감싸는 방법으로 예약어를 식별자로 사용할 수 있다.
ABSOLUTE | ACTION | ADD |
ADD_MONTHS | AFTER | ALL |
ALLOCATE | ALTER | AND |
ANY | ARE | AS |
ASC | ASSERTION | AT |
ATTACH | ATTRIBUTE | AVG |
BEFORE | BETWEEN | BIGINT |
BINARY | BIT | BIT_LENGTH |
BLOB | BOOLEAN | BOTH |
BREADTH | BY | |
CALL | CASCADE | CASCADED |
CASE | CAST | CATALOG |
CHANGE | CHAR | CHARACTER |
CHECK | CLASS | CLASSES |
CLOB | COALESCE | COLLATE |
COLLATION | COLUMN | COMMIT |
CONNECT | CONNECT_BY_ISCYCLE | CONNECT_BY_ISLEAF |
CONNECT_BY_ROOT | CONNECTION | CONSTRAINT |
CONSTRAINTS | CONTINUE | CONVERT |
CORRESPONDING | COUNT | CREATE |
CROSS | CURRENT | CURRENT_DATE |
CURRENT_DATETIME | CURRENT_TIME | CURRENT_TIMESTAMP |
CURRENT_USER | CURSOR | CYCLE |
DATA | DATA_TYPE | DATABASE |
DATE | DATETIME | DAY |
DAY_HOUR | DAY_MILLISECOND | DAY_MINUTE |
DAY_SECOND | DEALLOCATE | DEC |
DECIMAL | DECLARE | DEFAULT |
DEFERRABLE | DEFERRED | DELETE |
DEPTH | DESC | DESCRIBE |
DESCRIPTOR | DIAGNOSTICS | DIFFERENCE |
DISCONNECT | DISTINCT | DISTINCTROW |
DIV | DO | DOMAIN |
DOUBLE | DUPLICATE | DROP |
EACH | ELSE | ELSEIF |
END | EQUALS | ESCAPE |
EVALUATE | EXCEPT | EXCEPTION |
EXEC | EXECUTE | EXISTS |
EXTERNAL | EXTRACT | |
FALSE | FETCH | FILE |
FIRST | FLOAT | FOR |
FOREIGN | FOUND | FROM |
FULL | FUNCTION | |
GENERAL | GET | GLOBAL |
GO | GOTO | GRANT |
GROUP | ||
HAVING | HOUR | HOUR_MILLISECOND |
HOUR_MINUTE | HOUR_SECOND | |
IDENTITY | IF | IGNORE |
IMMEDIATE | IN | INDEX |
INDICATOR | INHERIT | INITIALLY |
INNER | INOUT | INPUT |
INSERT | INT | INTEGER |
INTERSECT | INTERSECTION | INTERVAL |
INTO | IS | ISOLATION |
JOIN | ||
KEY | ||
LANGUAGE | LAST | LEADING |
LEAVE | LEFT | LESS |
LEVEL | LIKE | LIMIT |
LIST | LOCAL | LOCAL_TRANSACTION_ID |
LOCALTIME | LOCALTIMESTAMP | LOOP |
LOWER | ||
MATCH | MAX | METHOD |
MILLISECOND | MIN | MINUTE |
MINUTE_MILLISECOND | MINUTE_SECOND | MOD |
MODIFY | MODULE | MONTH |
MULTISET | MULTISET_OF | |
NA | NAMES | NATIONAL |
NATURAL | NCHAR | NEXT |
NO | NONE | NOT |
NULL | NULLIF | NUMERIC |
OBJECT | OCTET_LENGTH | OF |
OFF | ON | ONLY |
OPTIMIZATION | OPTION | OR |
ORDER | OUT | OUTER |
OUTPUT | OVERLAPS | |
PARAMETERS | PARTIAL | POSITION |
PRECISION | PREPARE | PRESERVE |
PRIMARY | PRIOR | PRIVILEGES |
PROCEDURE | ||
QUERY | ||
READ | REAL | RECURSIVE |
REF | REFERENCES | REFERENCING |
RELATIVE | RENAME | REPLACE |
RESIGNAL | RESTRICT | RETURN |
RETURNS | REVOKE | RIGHT |
ROLE | ROLLBACK | ROLLUP |
ROUTINE | ROW | ROWNUM |
ROWS | ||
SAVEPOINT | SCHEMA | SCOPE |
SCROLL | SEARCH | SECOND |
SECOND_MILLISECOND | SECTION | SELECT |
SENSITIVE | SEQUENCE | SEQUENCE_OF |
SERIALIZABLE | SESSION | SESSION_USER |
SET | SET_OF | SETEQ |
SHARED | SIBLINGS | SIGNAL |
SIMILAR | SIZE | SMALLINT |
SOME | SQL | SQLCODE |
SQLERROR | SQLEXCEPTION | SQLSTATE |
SQLWARNING | STATISTICS | STRING |
SUBCLASS | SUBSET | SUBSETEQ |
SUBSTRING | SUM | SUPERCLASS |
SUPERSET | SUPERSETEQ | SYS_CONNECT_BY_PATH |
SYS_DATE | SYS_DATETIME | SYS_TIME |
SYS_TIMESTAMP | SYSDATE | SYSDATETIME |
SYSTEM_USER | SYSTIME | |
TABLE | TEMPORARY | THEN |
TIME | TIMESTAMP | TIMEZONE_HOUR |
TIMEZONE_MINUTE | TO | TRAILING |
TRANSACTION | TRANSLATE | TRANSLATION |
TRIGGER | TRIM | TRUE |
TRUNCATE | ||
UNDER | UNION | UNIQUE |
UNKNOWN | UPDATE | UPPER |
USAGE | USE | USER |
USING | UTIME | |
VALUE | VALUES | VARCHAR |
VARIABLE | VARYING | VCLASS |
VIEW | ||
WHEN | WHENEVER | WHERE |
WHILE | WITH | WITHOUT |
WORK | WRITE | |
XOR | ||
YEAR | YEAR_MONTH | |
ZONE |