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 “Enable delete functionality of database objects” in the File | Preference window. See “Customizing preferences”.
Count the number of records in a table or view