When you save changes to data in the table that you are updating, the appropriate commands (for example, UPDATE, INSERT, or DELETE) run on the database server. The SQL Results view displays messages that indicate whether the actions ran successfully.
The table data editor retrieves and displays the maximum number of rows that are specified in the SQL Results View Options page in the Preferences window.