The Describe Object dialog displays a detailed overview of all properties of a database object and allows their modification. The available functions depend on the type of the particular database object. Screenshots below show some tabs of selected Table object.
The objects are displayed in the Describe Object by clicking in the Schema Browser. There is always one Describe Object tab per one Connection. If you want to open an object in a new tab, click on it and hit Ctrl+Enter.
Moreover, you can search for an object by pressing CTRL+SHIFT+D. Then there are two ways to open the object. Either by pressing Enter, the object is opened in the Describe Objects tab. Or by pressing CTRL+Enter, the object code (if exists) is opened in the SQL Editor tab.
To sort data easily, click the column header. To filter them, use the WHERE clause.
To edit data, click the grid cell and edit the content. To confirm the changes, click Commit.
You can navigate from child table to parent table easily. Press CTRL key and move your mouse cursor over FK column value. Text will change to hyperlink. Click the hyperlink to see data in referenced table.
Example: Click value 30 in column DEPTNO in table EMP.
See details of selected record from table DEPT.