Customizing Table DDL

From ER/Studio Data Architect
Jump to: navigation, search

Go Up to Physical Storage Considerations

The options selected in the Table Editor determine the clauses used in the CREATE TABLE and CREATE INDEX statements. Options on the DDL tab can give you more control over the DDL created.

  1. Double-click a table to open the Table Editor.
  2. Click the DDL tab and then click Customize.

Notepad blue icon 2.pngNote: If the DDL is not displaying the options you expect to see, it may be because the relevant options on the DDL Tab Options dialog have not been selected.

The following describe options that require additional explanation:

  • Enclose names in quotes/brackets: To avoid object name conflicts, you can enclose in brackets or quotations all names or enclose only names that conflict with SQL keywords. If the database platform supports object names enclosed in brackets or quotes, these options are available in the General Options section of the DDL tab Options and the DDL Generation Wizard. If you select Enclose Names That Conflict with Keywords, then any column names that contain SQL keywords will be automatically enclosed in brackets.
  • Use Complete Syntax for Virtual Columns: This option is available for Oracle 11g and later. When this option is not selected, virtual columns will be added to the DDL with the following syntax:

column [<datatype>] AS (<column_expression>)

where <datatype> is set to the data type of the column if the Show Datatype option is on for the column and is omitted otherwise, and <column_expression> is the expression stored as the virtual column expression.

When this is selected, virtual columns will be added to the DDL with the following syntax:

column [<datatype>] GENERATED ALWAYS AS (<column_expression>) VIRTUAL

  • NUMBER datatype: NUMBER or NUMBER(*) you must set the width and scale to *. A width of 0 will be converted to * when generating DDL.

See Also