SQL Project Wizard

SQL Project Wizard

Use the SQL Project Wizard to automatically create entities and relationships for all database objects in the database tables selected in the New Database Tables and Views dialog box.

The SQL Project wizard suggests a set of entities and relationships from those available in the database and based on the tables selected. Tables that are exclusively join tables are not included in the list of potential entities.

When creating a project using the SQL Project Wizard, tables but not views are imported. Although most views are used for reporting purposes only, any views that are used for an English Query model can be imported after a project is created.

Proposed entities are grouped by the name of the table.

See Also

Creating an English Query Model

How to add or change a SQL connection

How to add tables and views from a SQL data source

Icons and Cursors Used in English Query

New <Database Object> Dialog Box