Skip to content

SQL capitalization identifier

shenhuan2021 edited this page Mar 3, 2024 · 39 revisions

Set identifier to preferred case option.

  • identifier

    Option: fmt102_case_identifier = lower, type: TFmtCase.

    SELECT department_id, 
           Min( salary )  
    FROM   employees  
    GROUP  BY department_id  
  • Quoted identifier

    Option: fmt103_case_quoted_identifier = lower, type: TFmtCase.

    SELECT [department_id], 
           Min( [salary] )  
    FROM   [employees]  
    GROUP  BY [department_id]  
  • Prefixed identifier

    Option: fmt104_case_prefixed_identifier = lower, type: TFmtCase. Prefixed identifier is user defined identifier. For example, you can define identifier start with fn_ as SQL Server system function. This format option apply to all prefixed identifiers.

Clone this wiki locally