Use the Query Designer to:
Browse the table catalog of any connected database of the current project.
Create SQL queries by using a graphical user interface.
Review generated SQL statements.
Execute SQL queries against the database.
Browse data in a selected table or view.
Create a table in the schema.
Delete all records in a table.
To delete all records in a table, select the “Enable delete functionality of database objects” option in the File | Preference window. See “Customizing preferences”.
Count the number of records in a table or view.