On Sun, 2023-01-15 at 22:15 -0800, AndyGo wrote: > If I'm writing all SQL by hand then personally, I'm going to always > use unquoted values for table/view names.
Working with Oracle, H2, MS SQL Server and DB2, I think best practise was to write SQL Keywords "lower case" and Identifiers "upper case" (maybe with Functions spelled "camel case", if you are adventurous). select COLUMN1, MY_COLUMN_2 from CFE.TABLE_NAME where Trim(COLUMN1)='something'; This will always work, with out without quoting. And its easy to read even when most SQL syntax highlighting is poor. Cheers Andreas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/826eceea5c9d6124655a2ec2a9728c2c14ba0a6c.camel%40manticore-projects.com.
