Skip to content

Create table statement

Tako Lee edited this page Mar 3, 2024 · 25 revisions

image

Delphi

  • gfmtopt.BEStyle_createtable_leftBEOnNewline, type of boolean, default is true

  • gfmtopt.BEStyle_createtable_leftBEIndentSize, type of integer,default is 2

  • gfmtopt.BEStyle_createtable_rightBEOnNewline, type of boolean, default is true

  • gfmtopt.BEStyle_createtable_rightBEIndentSize, type of integer,default is 2

  • gfmtopt.Createtable_ListitemInNewLine, type of boolean, default is true

  • gFmtOpt.Createtable_fields_alignWithCreateKeyword, type of boolean, default is false

  • Field in create table
    • gfmtopt.Createtable_Fieldlist_Align_option, type of TAlignOption, default is left
  • gFmtOpt.Createtable_Fieldlist_Style, type of TAlignStyle, , default is stacked
  • gFmtOpt.Createtable_Fieldlist_Comma_option, type of TLinefeedsCommaOption, , default is aftercomma

Java

  • TODO

Uniform

  • Create table fit into one line

    Option: fmt068_createtable_fit_into_one_line = true, type: TFmtBoolean.

    Try to fit statement into one line when length less than line width, it's this option is false, then won't try to do this.

    CREATE TABLE dbo.mytable ( low int, high int, myavg AS (low + high)/2 ) ;
  • Field list style

    • Fit into one line

      Option: fmt069_createtable_field_list_style = fit_into_one_line, type: TFmtListStyle.

      CREATE TABLE dbo.mytable 
        ( low int, high int, myavg AS (low + high)/2 ) ;
    • Stacked

      Option: fmt069_createtable_field_list_style = stacked, type: TFmtListStyle.

      CREATE TABLE dbo.mytable ( low  int,
                                 high int, 
                                 myavg AS (low + high)/2 ) ;       
      • Comma in the end of line

        Option: fmt070_createtable_field_list_comma_option = after_item, type: TFmtCommaOption.

        CREATE TABLE dbo.mytable ( low  int,
                                   high int, 
                                   myavg AS (low + high)/2 ) ;       
      • Comma in the begin of line

        CREATE TABLE dbo.mytable ( low   int
                                   ,high int 
                                   ,myavg AS (low + high)/2 ) ;       
      • Comma in the begin of line, align with fields

        CREATE TABLE dbo.mytable ( low  int
                                  ,high int 
                                  ,myavg AS (low + high)/2 ) ;       
      • Comma in the begin of line, align with fields, space between comma and field in 1 or n

        Option: fmt070_createtable_field_list_comma_option = before_item_outside_list_with_n_space, type: TFmtCommaOption.

        Option: fmt071_createtable_field_list_comma_space = n, type: int.

        CREATE TABLE dbo.mytable (  low  int
                                  , high int 
                                  , myavg AS (low + high)/2 ) ;       
  • Style of field list block

    Option: fmt072_createtable_field_list_start_parenthesis_in_newline = true, type: TFmtBoolean.

    Option: fmt073_createtable_field_list_start_parenthesis_indent = n, type: int.

    Option: fmt074_createtable_field_list_end_parenthesis_in_newline = true, type: TFmtBoolean.

    Option: fmt075_createtable_field_list_end_parenthesis_indent = n, type: int.

    Option: fmt076_createtable_field_list_first_field_in_newline = true, type: TFmtBoolean.

    Option: fmt077_createtable_field_list_first_field_indent = n, type: int.

    CREATE TABLE dbo.mytable 
      ( 
        low  int,
        high int, 
        myavg AS (low + high)/2 
      ) ;       
  • Create table as select, indent AS keyword from 0 to n

    Option: fmt078_createtable_subquery_as_in_newline = true, type: TFmtBoolean.

    Option: fmt079_createtable_subquery_as_indent = n, type: int.

    CREATE TABLE suppliers
      AS (SELECT *
          FROM companies
          WHERE id > 1000);
Clone this wiki locally