Page 110 - SQL

Chapter 30: Identifier

Introduction

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.

Examples

Unquoted identifiers

Unquoted identifiers can use letters (a-z), digits (0-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)
• MySQL: $ (source)
• Oracle: $, #, and other letters from database character set (source)
• PostgreSQL: $, and other Unicode letters (source)

Unquoted identifiers are case-insensitive. How this is handled depends greatly on SQL
implementation:

• MS SQL: Case-preserving, sensitivity defined by database character set, so can be case-
sensitive.

• MySQL: Case-preserving, sensitivity depends on database setting and underlying file
system.

• Oracle: Converted to uppercase, then handled like quoted identifier.

• PostgreSQL: Converted to lowercase, then handled like quoted identifier.

• SQLite: Case-preserving; case insensitivity only for ASCII characters.

Read Identifier online: https://riptutorial.com/sql/topic/9677/identifier

https://riptutorial.com/ 92