Edit Database Schema

Figure 0.5 Edit Database Schema

You can edit the database schema saved in TurboData. Create, update and delete tables an columns with this dialog.

All the tables in the schema are shown in the top grid. When a table is selected, all the columns for that table are shown in the bottom grid.

This example shows the Order Table has been selected from the Customer Order sample database distributed with TurboData. The Creation Date and Creation Time columns have been updated from a timestamp data type, to date and time data types. This is one way of making TurboData manipulate a specific part of the timestamp data when generating test data for a Jet database.

More:

Clear FK (Foreign Key)

Set FK (Foreign Key)


Contents Previous Next