Skip to content

SQL capitalization table

Tako Lee edited this page Mar 11, 2014 · 8 revisions

Table name has a dedicated case option.

Option: fmt105_case_table_name = upper, type: TFmtCase.

SELECT department_id, 
       Min( salary )  
FROM   EMPLOYEES 
GROUP  BY department_id  
Table mapping file

User can also specify a table mapping file that all tables should be capitalized exactly the same as the one in this file. Table name in this mapping file should be one table per line with desired case. If table name is not found in this mapping file, then case option for table name applied.

Clone this wiki locally