Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Filter and Sort Dialog Box

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.

© 2015 Microsoft