For Table Security
and easy user access Microsoft added options for Rename table. You can give any Name
for each table before import the table into model.
For example i have given some Friendly name for few tables.
Now come to Filer option of the table data.
To do that you have to select particular table and click on "Preview & Filter" button.
Now we can see Product table with all the columns. But in our model we have no need for all the columns in 'Product' Table. To unselect the column, we have to untick the check box near specific column.
Here i have removed 2 column from 'Product' table by untick the SpanishProductName and FrenchProductName.
Apart form that we can apply filter on specific selected column also.
After filter click on 'Finish' Button.
No comments:
Post a Comment