# Object Tree

Browse your Oracle schema visually — tables, views, packages, procedures, and more.

Source: https://www.nexosqlstudio.com/docs/object-tree
Language: en
Type: docs

# Object Tree

## Database support

Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.

[Supported databases and feature availability](https://www.nexosqlstudio.com/databases) · [Connection guides](https://www.nexosqlstudio.com/docs/getting-started)

The Object Tree gives you a visual, tree-structured view of every object in your connected Oracle schema — from tables and views to packages, procedures, functions, triggers, and sequences.

## Opening the Object Tree

The Object Tree lives in the **Connections Explorer** sidebar. Expand a connection node to reveal the object type folders:

- 📁 **Tables**
- 📁 **Views**
- 📁 **Packages**
- 📁 **Procedures**
- 📁 **Functions**
- 📁 **Triggers**
- 📁 **Sequences**
- 📁 **Types**
- 📁 **Synonyms**
- 📁 **Database Links**

Expand any folder to see the individual objects.

## Searching & Filtering

Use the **search icon** (🔍) in the Connections Explorer toolbar to filter objects by name. The filter applies across all object types simultaneously.

```
Type: EMPLOYEES
Finds: EMPLOYEES (table), EMPLOYEES_SEQ (sequence), etc.
```

The filter is cleared when you close the search box.

## Go to Definition

Double-click any object in the tree to open its DDL in an edit block — or use **Go to Definition** (`F12`) from any symbol reference in a SQL/PL/SQL editor.

## Object Details and Actions

Right-click an object and choose **View Object Details** to open a webview panel showing:

- Full DDL source
- Column list (for tables/views)
- Grants and privileges
- Dependent objects and related metadata where Oracle exposes it

## Rename & Refactor

Right-click a supported object and choose **Rename**. Nexo SQL Studio prepares the Oracle rename operation and prompts before execution.

## Refreshing the Tree

Refresh manually with the **Refresh** icon in the toolbar or by right-clicking a node and choosing **Refresh**.

## Cross-Schema Browsing

You can browse objects in other schemas by expanding the **Other Schemas** node at the bottom of the tree. Your user must have the necessary `SELECT ANY` or `SELECT_CATALOG_ROLE` privileges.