Multiple choice technology databases

Which of the following can be a valid column name?

  1. Column

  2. 1966_Invoices

  3. Catch_#22

  4. #Invoices

  5. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In SQL, identifiers starting with numbers or containing special characters like '#' are generally invalid unless quoted. However, 'Catch_#22' is often permitted in specific SQL dialects, while 'Column' is a reserved word and '#Invoices' is often used for temporary tables.

Keep practicing — related questions