SQL Identifiers
SQL identifiers are names used for different elements within Databend, such as tables, views, and databases.
Unquoted & Double-quoted Identifiers
Unquoted identifiers begin with a letter (A-Z, a-z) or underscore ("_") and may consist of letters, underscores, numbers (0-9), or dollar signs ("$").
Examples:
mydatabend
MyDatabend1
My$databend
_my_databend
Double-quoted identifiers can include a wide range of characters, such as numbers (0-9), special characters (like period (.), single quote ('), exclamation mark (!), at symbol (@), number sign (#), dollar sign ($), percent sign (%), caret (^), and ampersand (&)), extended ASCII and non-ASCII characters, as well as blank spaces.
Examples:
"MyDatabend"
"my.databend"
"my databend"
"My 'Databend'"
"1_databend"
"$Databend"
Note that using double backticks (``) or double quotes (") is equivalent:
Examples:
`MyDatabend`
`my.databend`
`my databend`
`My 'Databend'`
`1_databend`
`$Databend`