The following steps explain how to directly edit the data in a table or simple view.
This functionality is not available when connected by ODBC.
- Right-click a Table or View name in the Database Explorer Tree, then select Edit Table.
In the Edit Table Filter dialog, deselect any columns you do not want in the output.
The selected columns must include a unique column or key if you plan to update the data. LOB columns do not appear in the list. Columns defined as Not Null are disabled because they are always selected.
- [Optional] Enter a Where clause to limit the rows returned and an Order by clause to specify the initial sort order of the displayed rows.
- Press OK to display the matching data in the Edit Table Filter dialog.