A table design is a kind of blue print for a database table. It is not a physical table. When you create a table design in the Data Designer, no physical database table is created (yet). A table design might contain index definitions as well.
When your table design is ready, click the CREATE button to create the table and its indexes. If you modified a design of an existing (reverse engineered) table, click the ALTER button to alter the table.
Create a new table design
There are two ways to create a new table design:
- Click on Design new table at the top of the Data Explorer main page to create a new table design.
- Navigate to the Data Designer menu and click on Design new table at the top of the Data Designer page to create a new table design.
Create a table design from an existing database table
Call the Data Designer directly from the Data Explorer to alter specific tables. Find your table, click the Manage link and click ALTER on the Actions tab.
Local and remote databases
The Data Designer can be used for local as well as remote databases, presuming you have the necessary privileges.
Basic – Start here if you have absolute no experience in data modelling.
Advanced – Use this option to create tables if you have some basic understanding of database tables.
Developer – If you are an experienced developer, you can write your own scripts and use the Data Explorer to execute them. More…
Use reverse engineering to create a table design from an existing table. Indexes are reverse engineered as well. The Data Designer allows you to make modifications to your table design and then either alter your existing table or create a new one.
The reconcile feature performs a reverse engineering action on the selected table. The actual table design will be overwritten with the reverse engineered version. After a reconcile action, the table design matches the structure of the physical table.