Table Designer

The Table Designer is a powerful tool for managing the structure and properties of database tables. The Table Designer allows you to create new tables or alter the existing ones in a similar way. To design a new table double-click the Create table in design view item within the Profile Window | Tables page. To design the existing table select its name within the Profile Window | Tables page and click the Design button on the toolbar or in the popup menu.

The Table Designer window is divided into three tabs. The Columns tab is provided for managing the list of table columns and their properties, the Indexes allows you to add, alter, or drop indexes for table fields, and the Options tab contains basic table properties, such as table name, table type, etc.

Please refer to topics Designing Table Columns, Designing Table Indexes, Designing Table Options respectively for details.

Besides table graphical representation, Table Designer also provides you with the SQL View of the table. This view is accessible through the SQL View button and displays the CREATE TABLE statement with all columns, indexes, and options, which will be used on creating the new table, or altering the existing one.

All changes made to the table design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved table design, click Revert.