예약어¶
아래는 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 |