Skip to content

SQL capitalization alias

shenhuan2021 edited this page Mar 3, 2024 · 5 revisions

Delphi

Java

  • TODO

Uniform

  • Alias name has a dedicated case option.

Option: fmt108_case_alias_name = upper, type: TFmtCase.

SELECT p.name      AS PRODUCT, 
       p.listprice AS 'LIST PRICE', 
       p.discount  AS 'DISCOUNT'  
FROM   production.product p  
       JOIN production.productsubcategory s  
         ON p.productsubcategoryid = s.productsubcategoryid  
Column alias name

Option: fmt110_case_column_alias_name = upper, type: TFmtCase.

User can set dedicated case option for column alias name, this make column alias differs from other alias.

Clone this wiki locally