Item 

Description 

Use a dataset to suggest table and column names  

By checking this option, you are presented with a list of available typed datasets, if any, which will provide existing table and column names. Returns only a list of names from the schema of the given typed dataset. Does not apply to standard datasets.  

Dataset  

Displays the names of datasets that you can use for a model.  

Source table  

Displays the name of the data source table. Because a data adapter can reference more than one table, you can select from multiple tables in the data source, if available.  

Dataset table  

Displays the name of the dataset table. Because you can create datasets that contain multiple tables, you might see multiple tables listed here.  

Source columns  

Displays the names of all columns in the data source table.  

Dataset columns  

Displays the names of columns in the dataset to write the data source table columns to. When performing updates to the data source, these are the columns that will be read from. You can change the names to map one column to another non-corresponding column, or you can map to corresponding columns between the source table and the dataset.  

Delete  

Deletes the active column names in both source and dataset column lists. Deleted columns will not appear in the dataset. Useful if your query returns more columns from the data source than you need to use in the dataset.  

Reset  

Resets the list of source table column names and dataset column names to their original values.  

Enter key  

You can add a row by pressing Enter while the cursor is in the last row of the dataset column. This allows you to create new columns which might exist already but don't display at designtime, for some reason. For example, if you have derived or computed fields that you want to keep track of, you could add a new column to account for that data. The order of columns does not have any impact on the data.