|SQL Language Reference / Keywords and Identifiers|
Two categories of identifiers are defined in SQL-92 standard: ordinary and delimited.
The rules mentioned here for SQL identifiers apply to all names used in SQL statements including table-name, column-name, view-name, synonym-name, constraint-name, correlation-name, index-name, trigger-name, function-name and procedure-name. There are two categories of identifiers as defined in SQL-92 standard: ordinary and delimited. The ordinary names must follow the below mentioned rules:
Delimited identifiers are those enclosed within double quotation (") marks. If the identifier itself needs to have a double quotation mark then two consecutive double quotation marks should be used.
The following conventions are used in the syntax definitions in the remaining document: