Change the data

You may need to change your data, in order to test your report designs.

While you can write SQL statements, DB Explorer is designed to allow you to make data changes directly within the user interface, to the data shown.

Use DB Explorer to quickly view or make changes to your data. It is important to understand that, by using DB Explorer, you are making actual changes to the data in the tables; these changes are permanent. As such, DB Explorer is intended as a developer tool, not as a production tool.

When you change or modify data using this tool, the changes are done under-the-covers by SQL statements. These SQL statements are governed by the rules of the database itself. The change needs to be valid by the rules of the database, in order for the query to run successfully.