Restriction | Regular Identifiers | Delimited Identifiers |
Quotes | Specified without quotes | Specified in double quotes |
Keywords | Cannot be a keyword | Can be a keyword |
Case | Depends on host DBMS | Is significant |
Valid Special Characters | “At” sign (@) (Ingres only) Crosshatch (#) (Ingres only) Dollar sign ($) (Ingres only) Underscore (_) | Ampersand (&) Asterisk (*) “At” sign (@) Colon (;) Comma (,) Crosshatch (#) Dollar sign ($) Double quotes (") Equal sign (=) Forward slash (/) Left and right caret (< >) Left and right parentheses Minus sign (‑) |
Percent sign (%) Period (.) Plus sign (+) Question mark (?) Semicolon (;) Single quote (') Space Underscore (_) Vertical bar (|) |