Ключевые слова и идентификаторы#

Зарезервированные ключевые слова#

В таблице ниже приведен список ключевых слов, зарезервированных в CedrusData, и их статус в стандартах SQL. Зарезервированные ключевые слова должны быть окружены двойными кавычками при использовании в качестве идентификаторов.

Keyword

SQL:2016

SQL-92

ALTER

reserved

reserved

AND

reserved

reserved

AS

reserved

reserved

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

EXECUTE

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

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

Идентификаторы#

Идентификаторы задают имена каталогов, схем, таблиц, колонок, функций и других объектов. Идентификаторы должны начинаться с буквы и содержать буквенно-цифровые символы или подчеркивания.

Если в идентификаторе присутствуют иные символы, то идентификатор должен быть окружен двойными кавычками ("). Если имя идентификатора содержит двойные кавычки, то они должны быть экранированы дополнительными двойными кавычками.

Идентификаторы нечувствительны к регистру (case insensitive).

Примеры:

tablename
SchemaName
example_catalog.a_schema."table$partitions"
"identifierWith""double""quotes"

Следующие идентификаторы должны быть окружены двойными кавычками:

table-name
123SchemaName
colum$name@field