Database Objects section (SQL editor) |
|
The SQL editor will show the database objects in
this section. Open the schema of interest and within that the tables or views
list to see the database objects you can use. Each item in the tree has
different behavior. The action menu presented in the menu bar but also when you
right click the item shows the actions you can perform on that object. You can
drag and drop items into the SQL text area. You can also right click an item and
select an action. You can generate most used SQL statements from this menu.
Typically the database objects list shows the following details:
| Schemas | This is the container where all your and other users database objects reside. |
| -Schema | Within schemas you find the list of schemas / users. Some database
types can only have one schema so the items will be titled "Current
Schema" From the actions menu can can describe all tables and views. |
| --Tables | The tables list shows all tables found in the database. Available actions: -Select: create a select * statement for all tables in the list -Create: shows the table creation wizard -Count rows in all tables -Describe all tables -Sample rows from all tables |
| --Views | The tables list shows all tables found in the database. Available actions: -Select: create a select * statement for all tables in the list -Count rows in all views -Describe all views -Sample rows from all views |
See also: