SQL language elements:
Single Line Comment | # | -- | Until the end of line, -- must be followed by a space or tab |
Names for database objects such as databases, tables, views, columns, indexes, triggers, procedures etc.
First character | Alphanumeric | ||
Subsequent characters | Alphanumeric, _ (underscore) and $ (dollar) | ||
Identifier quote character | ` (backtick) | " (double quotes) if ANSI_QUOTES mode is set (not set by default) |
Maximum length:
Databases, tables, columns, indexes, views, procedures, triggers, constraints | 64 |