The DataObjects Schema Designer provides an Import Wizard that creates a schema based on the structure information stored in a database. It creates simple tables based on database tables, and simple relations between them based on foreign key constraints stored in the database. Tables are created with fields according to the field structure of the database tables. Field properties, such as DataType, PrimaryKey and others are set according to the database field properties. Later, you can customize table fields, change their properties, delete unnecessary fields, change the fields order, and add new fields, not necessarily based on database table fields.
Importing the database structure also creates a database connection (in the Connections window of the Schema Designer), that you can use later to connect to the database while editing the schema. For more information on importing a database structure, see Creating a Schema with the Import Wizard.
After you have imported the database structure, you can modify the schema, add tables (simple and composite), create relations, and so on. After import, the Schema Designer is connected to the database, so the Database Tables window is filled with the list of all database tables with their fields; this is highlighted in the image below:
To connect to the database, select Connect to database in the Schema menu, specify the connection and optional parameters in the Connect to database dialog box, and click OK.