Skip to content

SQL capitalization column alias

shenhuan2021 edited this page Mar 3, 2024 · 1 revision

Delphi

Java

  • TODO

Uniform

  • Alias column name has a dedicated case option.

    Option: fmt110_case_column_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  

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

Clone this wiki locally