Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.