Open topic with navigation
In SQL Explorer, you can modify table content by adding new records (rows) as well as by updating or removing rows.
In the context tree, double-click the table whose content you want to modify. SQL Explorer opens a new query tab that displays the query it executes. For example, if you select the
HOCKEY table then the query is
SELECT * FROM HOCKEY. The result of the query appears in the Query Result panel.
NULLappears at the right side of each field that you can populate. To populate a field, click its instance of
NULLand enter a value. When you are done populating fields, click Update, which appears just below the new row. Alternatively, you can can press Enter to save the new row. SQL Explorer executes an
INSERTstatement, which adds the record, populates the fields with the values you specified, initializes null fields with default values, and adds any auto-generated field values, for example, a unique ID. To see the new row, along with any generated values, re-execute the query by selecting Execute from the query editor menubar.
NULLto clear that field. For a field to which you want to add content, click its instance of
NULL. When you are done editing click Update or press Enter.