TableEdit

To use this feature administrative permissions must be given. True to its name, TableEdit gives the ability to edit database tables. Editing can be done by adding, deleting, or changing the current data. This can be especially useful when modifying "lookup" tables.

To Use Table Edit

First select a table in SQL Manager.
Click the refresh () button to see the data currently in the table.
To add a row of data, click the add record () button in the toolbar or right click on a cell and select the Add Record option.
Data can now be added to the new row, simply by selecting a cell and typing in the data
To edit any existing data, click on the cell containing the data and type in the new information.
To delete a row of data, highlight the whole row and click the delete record button () in the toolbar or right click and select the delete record option.
To save your changes and exit out of the TableEdit program click the save button
( )

Note

Any included media files can be viewed by right clicking on the cell and selecting the open reference option.