Ключевые слова и идентификаторы#
Зарезервированные ключевые слова#
В таблице ниже приведен список ключевых слов, зарезервированных в CedrusData, и их статус в стандартах SQL. Зарезервированные ключевые слова должны быть окружены двойными кавычками при использовании в качестве идентификаторов.
Keyword |
SQL:2016 |
SQL-92 |
---|---|---|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
|
|
reserved |
|
|
reserved |
|
|
reserved |
|
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
|
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
|
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
|
reserved |
reserved |
Идентификаторы#
Идентификаторы задают имена каталогов, схем, таблиц, колонок, функций и других объектов. Идентификаторы должны начинаться с буквы и содержать буквенно-цифровые символы или подчеркивания.
Если в идентификаторе присутствуют иные символы, то идентификатор должен быть окружен двойными кавычками ("
).
Если имя идентификатора содержит двойные кавычки, то они должны быть экранированы дополнительными двойными кавычками.
Идентификаторы нечувствительны к регистру (case insensitive).
Примеры:
tablename
SchemaName
example_catalog.a_schema."table$partitions"
"identifierWith""double""quotes"
Следующие идентификаторы должны быть окружены двойными кавычками:
table-name
123SchemaName
colum$name@field