Tuesday 21 January 2020

CQL: Identifiers and Keywords


Identifiers
Identifiers are alpha numeric strings, used to identify tables, columns and other objects. An identifier in CQL, must match to the regular expression ‘[a-zA-Z][a-zA-Z0-9_]*’.

Keywords
Keywords are subset of identifiers, which has special meaning in CQL.

Example
SELECT, UPDATE, WHERE, WITH are all keywords in cql.

Identifiers and keywords are case insensitive
Identifiers and keyword names are case insensitive.

For example,
a.   UPDATE, update, update are all same in CQL.
b.   firstName, firstname, FIRSTname are all same

Quoted Identifiers
Quoted identifiers are defined by enclosing the name in double quotes "". Quoted identifiers are case sensitive.

Previous                                                    Next                                                    Home

No comments:

Post a Comment