How to add tables and views from a SQL data source

Tables or views that exist in the SQL data source can be added to SQL-enabled models.

To add tables from a SQL data source

1. In the Project Explorer window, double-click the module file (.eqm) in the project to the tables are to be added.

   The Model Editor specific to that project and the Model menu appear.

2. On the Model menu, click Import Tables.
   
   
3. In the Available list of the New Databases Tables and Views dialog box, double-click the table, tables, or views to make them accessible to the model, and then click OK.

   To add all of the tables, click the >> button.

   To remove a table, select it from the Selected list, and then click the < button.

See Also

Model Editor

New <Database Object> Dialog Box