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
- 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.
- On the Model menu, click Import Tables.
- 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.