Filtering Table Data

Use the Table Data Filter dialog to filter data by selecting columns to filter, a Where clause, and Order by values. You can also set the maximum number of rows to retrieve. You can set up filter criteria to improve performance on larger tables and to focus on data that you want to work on.

Note: Select Do Not Show This Dialog Again to bypass the Table Data Filter dialog when opening the Table Data Editor. You can also set this option permanently in the Table Data Editor preferences page.
  1. Open a table in the Table Data Editor.
  2. To specify a filter for a column, clear the check box next to the column name.
  3. Specify a Where clause.
  4. Specify an Order By clause.
  5. Specify the Maximum Rows Retrieved.
  6. Click OK.

    The table opens for editing and displays data based on the filter criteria you set.

Related concepts
Table Data Editor
Related tasks
Editing Table Data
Extracting Table Data
Truncating Table Data

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com