Filter and Sort Dialog Box
In SQL Server Object Explorer, you can right click a table or view and select View Data (for more information see How to: View and Edit Data in a Table). Beginning in the March 2014 release of SQL Server Data Tools, the Data Editor has a Sort and filter button in the toolbar. You can modify the data that is displayed in a table or view.
In the Filter and Sort dialog box, you can specify which data will be displayed in the Data Editor :
Number of rows displayed.
Which columns to display.
Aliases for column names.
Constraints to display columns.
Sort order of columns.
You can also right click on a row and in the Filter and Sort dialog box and select an operation to perform on a row.
Other ResourcesConnected Database Development