Choosing Format options

To choose from different format options for the generated SQL, you must be on the Generate SQL dialog. This task is described in Generate SQL for database objects.

  1. Select the Format tab on the Generate SQL dialog. These valuesare used to format time, dates, and literal constants in your generated SQL.Someformat options are not compatible with some standards options. For more information, see Formats supported by the standards
  2. Select a Naming convention
  3. Select a Decimal separator
  4. Select a Time format and separator
  5. Select a Date format and separator

You have now chosen the format for the generated SQL.

Next, you can change the default values for:

Output options

SQL options

You can do these tasks in any order. Additionally, you can:

Add or remove list objects

Once you are satisfied with these options, click Generate.