Skip to content

SQL capitalization alias

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

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