This topic is about identifiers, i.e. syntax rules for names of tables, columns, and other database objects.
Where appropriate, the examples should cover variations used by different SQL implementations, or identify the SQL implementation of the example.
# Unquoted identifiers
Unquoted identifiers can use letters (
z), digits (
9), and underscore (
_), and must start with a letter.
Depending on SQL implementation, and/or database settings, other characters may be allowed, some even as the first character, e.g.
- MS SQL:
#, and other Unicode letters (source (opens new window))
$(source (opens new window))
#, and other letters from database character set (source (opens new window))
$, and other Unicode letters (source (opens new window))
Unquoted identifiers are case-insensitive. How this is handled depends greatly on SQL implementation: