Reverse Engineer Wizard: Select types of objects

Select the types of objects that you want to reverse engineer. If an item is grayed out, that means there isn't any such element in the target database that you've selected.

Tables

Select this check box to extract tables from the target database.

Primary Keys

Select this check box to extract primary keys from the target database.

Indexes

Select this check box to extract indexes from the target database.

Foreign Keys

Select this check box to extract foreign keys from the target database.

Triggers

Select this check box to extract triggers, including trigger code, from the target database.

Check Clauses

Select this check box to extract check clauses, including check-clause code, from the target database.

Views

Select this check box to extract views from the target database.

Stored Procedures

Select this check box to extract stored procedures, including procedure code, from the target database.

About this wizard

This wizard steps you through the process of creating a connection to the target database you want to reverse engineer.

To create a connection, you specify an installed Visio driver and the 32-bit ODBC (Open Database Connectivity) data source. For convenience, before you run the wizard, you should set the default Visio driver and target database to the target database you want to reverse engineer.

The schema definition information that the wizard can extract depends upon a combination of things, such as the capabilities of the DBMS (Database Management System) and ODBC driver. To the extent that it is available from the target DBMS, you can select the schema definition information that the Reverse Engineer Wizard will extract.

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

×