Set the Database Type

The most important property to set for a table (after its name) is the database type. This defines the list of data types that are available for defining columns, and also declares which dialect of DDL is generated.

If this is not set, tables are created without a DBMS type and field typing cannot be allocated when creating new fields in the table.

You can set the database type to default to the required DBMS. However, if you have not set a default or want to change the value for specific tables, you can set the DBMS for each table individually.

Access Table element | Element | Properties | General

Reference

Field/Button

Action

See also

Database

Click on the drop-down button and select the required database type from the list.