키워드와 식별자
키워드와 식별자 (Keywords and identifiers)
Trino에서 예약 키워드(reserved keywords)로 사용되는 단어들과, 식별자(identifier)를 쓸 때 지켜야 할 규칙을 설명해요. 예약 키워드를 식별자로 쓰려면 큰따옴표로 감싸야 해요.
출처: 문서
본문
예약 키워드 (Reserved keywords)
다음 표는 Trino에서 예약된 키워드 목록과 SQL 표준에서의 상태를 보여 줘요. 이 예약 키워드들을 식별자로 사용하려면 큰따옴표(`"')로 감싸서(quote) 써야 해요.
| 키워드 | SQL:2016 | SQL-92 |
|---|---|---|
ALTER |
reserved | reserved |
AND |
reserved | reserved |
AS |
reserved | reserved |
AUTO |
||
BETWEEN |
reserved | reserved |
BY |
reserved | reserved |
CASE |
reserved | reserved |
CAST |
reserved | reserved |
CONSTRAINT |
reserved | reserved |
CREATE |
reserved | reserved |
CROSS |
reserved | reserved |
CUBE |
reserved | |
CURRENT_CATALOG |
reserved | |
CURRENT_DATE |
reserved | reserved |
CURRENT_PATH |
reserved | |
CURRENT_ROLE |
reserved | reserved |
CURRENT_SCHEMA |
reserved | |
CURRENT_TIME |
reserved | reserved |
CURRENT_TIMESTAMP |
reserved | reserved |
CURRENT_USER |
reserved | |
DEALLOCATE |
reserved | reserved |
DELETE |
reserved | reserved |
DESCRIBE |
reserved | reserved |
DISTINCT |
reserved | reserved |
DROP |
reserved | reserved |
ELSE |
reserved | reserved |
END |
reserved | reserved |
ESCAPE |
reserved | reserved |
EXCEPT |
reserved | reserved |
EXISTS |
reserved | reserved |
EXTRACT |
reserved | reserved |
FALSE |
reserved | reserved |
FOR |
reserved | reserved |
FROM |
reserved | reserved |
FULL |
reserved | reserved |
GROUP |
reserved | reserved |
GROUPING |
reserved | |
HAVING |
reserved | reserved |
IN |
reserved | reserved |
INNER |
reserved | reserved |
INSERT |
reserved | reserved |
INTERSECT |
reserved | reserved |
INTO |
reserved | reserved |
IS |
reserved | reserved |
JOIN |
reserved | reserved |
JSON_ARRAY |
reserved | |
JSON_EXISTS |
reserved | |
JSON_OBJECT |
reserved | |
JSON_QUERY |
reserved | |
JSON_TABLE |
reserved | |
JSON_VALUE |
reserved | |
LEFT |
reserved | reserved |
LIKE |
reserved | reserved |
LISTAGG |
reserved | |
LOCALTIME |
reserved | |
LOCALTIMESTAMP |
reserved | |
NATURAL |
reserved | reserved |
NORMALIZE |
reserved | |
NOT |
reserved | reserved |
NULL |
reserved | reserved |
ON |
reserved | reserved |
OR |
reserved | reserved |
ORDER |
reserved | reserved |
OUTER |
reserved | reserved |
OVERLAPS |
reserved | reserved |
PREPARE |
reserved | reserved |
RECURSIVE |
reserved | |
RIGHT |
reserved | reserved |
ROLLUP |
reserved | |
SELECT |
reserved | reserved |
SKIP |
reserved | |
TABLE |
reserved | reserved |
THEN |
reserved | reserved |
TRIM |
reserved | reserved |
TRUE |
reserved | reserved |
UESCAPE |
reserved | |
UNION |
reserved | reserved |
UNNEST |
reserved | |
USING |
reserved | reserved |
VALUES |
reserved | reserved |
WHEN |
reserved | reserved |
WHERE |
reserved | reserved |
WITH |
reserved | reserved |
식별자 (Identifiers)
카탈로그·스키마·테이블·컬럼·함수 또는 다른 객체의 이름을 나타내는 토큰을 식별자라고 해요.
식별자는 문자(letter)로 시작해야 하며, 그 뒤에 영숫자(alphanumeric) 문자와 밑줄(underscore)을 포함할 수 있어요. 다른 문자를 가진 식별자는 큰따옴표(")로 둘러싸야 해요. 큰따옴표로 둘러싸면 어떤 문자든 쓸 수 있고, 따옴표로 둘러싸인 식별자 안에서 "를 쓰려면 그 앞에 또 하나의 큰따옴표를 붙여 이스케이프해요.
식별자는 대소문자를 구분해 취급하지 않아요.
유효한 예시는 다음과 같아요.
tablename
SchemaName
example_catalog.a_schema."table$partitions"
"identifierWith""double""quotes"
Trino에서 유효하지 않아 사용할 때 반드시 따옴표로 감싸야 하는 식별자는 다음과 같아요.
table-name
123SchemaName
colum$name@field
더 알아보기 (Learn more)
키워드와 식별자 규칙을 익혔어요. 이어서 SQL에 설명을 남기는 방법인 주석(Comments)을 살펴보면 좋아요.