The Database Wizard dialog box enables you to manage Database Structure Descriptors (DSDs) of your web site.
Your site can contain any number of DSDs. All DSDs that you create or import to your site must correspond to real databases declared as ODBC Data Sources. A real database is the one that has been created and placed on a server and registered as a data source available through ODBC. For more information, refer to your ODBC guide of your database program. These databases should be present on the same Server where you are going to place or publish your web site. Names of databases, tables and fields declared in a descriptor must be identical to the names of databases, tables and fields declared in the ODBC datasource. Note that you cannot declare any table or field that is not present in the database.
The Data base wizard dialog box consists of a database tree window and database management buttons and controls.
The Database Tree window shows structure of all databases used in your web site. The structure is shown in a form of a tree hierarchy - databases are at the lowest level. They contain one or more tables.
The Database Tree window enables drag-and-drop editing. You can drag a table and drop it into another database. You can drag a field and drop it into another table. Right click on an item to display the context sensitive menu.
The Database Management Buttons and Controls are the following:
Add. Adds a new database, table or field. The same type of object that you have selected will be added. For example, if you have selected a table, this button will insert another table at the end of the list. The Add operation can be performed with the Ins button.
Insert. Inserts an object of a higher level. For example: if you select a table and click Insert, a field will be inserted into your table.
Delete. Deletes a selected object. The Delete operation can be performed with the Del button.
Rename. Changes a name of a selected object.
Properties . enables you to change properties of a field. Select the desired field and click the Properties button. The Field Properties dialog box will emerge.
Open Library . enables you to manage a library of DSDs. Click the Open Library button. The Database Library dialog box will be displayed.