---
title: "Database Tree"
slug: "database-tree"
updated: 2023-07-11T18:00:02Z
published: 2023-07-11T18:00:02Z
canonical: "docs.datajet.app/database-tree"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Database Tree

## Data Catalog

The Data Catalog shows all the tables and fields in the current project schema.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1669136024468.png)

The number of records in the table is displayed next to the table name:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1669135868554.png)

Low cardinality Fields (less than 256 discrete values) will include a list of unique values:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1643108690948.png)

### Wide Tables

Tables with a large number of fields (many hundreds) will not display their field list in the Database Tree. To work with tables that have a high number of fields, use the Database List.

## Context Panel

Selecting a Field will show a profile in the [Context Panel](/v1/docs/context-panel-getting-started). If there are less than 256 discrete values, a bar chart will be available. If there are less than 24 discrete values, a pie-chart will also be available. The counts for each field value are displayed in a searchable, sortable, selectable grid.

**![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1669135592522.png)**

### **Drag To Hotbar**

- Tables are a dataset source for the whole table - **drag a table** into the [HotBar](/v1/docs/dataset-hotbar-getting-started) to select all records in the table
- Fields are a dataset source - **drag a field** into the HotBar to bring up a [Field Query Box](https://datajet.document360.io/docs/dataset-hotbar-quick-reference#creating-datasets-from-fields)
- Dataset fields can be dragged directly into the HotBar - **drag a Dataset field** and drop into the HotBar to select all records where Dataset Field = 1

![DragToHotBar](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/DragToHotBar.PNG)

### Drag To Workspace

- **Drag a table** into the [Workspace](/v1/docs/workspace-quick-reference) window and choose DataView to open a [DataSet Scratch](/v1/docs/dataset-scratch)Tab for the table - this will display the underlying records.
  - **Drag Fields onto the grid** to add columns to the view

![Drag Table2](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/Drag%20Table2.PNG)

- **Drag a field** into the [Workspace](/v1/docs/workspace-quick-reference) window and choose which action to take.  The available actions will depend on the type of field:

![Drag Field](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/Drag%20Field.PNG)

### 

#### Drag table onto the Main Tab Bar

- display as a dataset
- display as a dataview
- get the quick audit details of field in the table

#### Drag field onto the Main Tab Bar

- profile
  - index profile
  - open a dataset with Field Query Box opened
  - open a dataview of the whole table with selected field in it's template
  - open a Statistics Report for that field (if applicable)

Dragging a field between two joined tables will popup an option to copy up/down than field.

### Drag To Another Database Object

It is possible to drag and drop fields and tables on top of each other.

## Right-Click Menus

Right-clicking an item brings up the Context Menu for that item:

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1688489111163.png)

See [Database Right-Click](/v1/docs/database-right-click-menus) for more information.

### Micro-Toolbar

The tree view's micro-toolbar allows switching between tree or list view and filterer and sorting the contents of either

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1643109073106.png)

#### Dragging Within The Tree

**Tip:** When dragging from a field to a table in a large database, it may be easier to open a new Entity Selector from the tools menu and use that as a drag target.

## Filtering The View

Open and close the filter box by clicking on the filter icon in the micro-toolbar.

The combo box allows filtering by field data type, the textbox by wildcard non case-sensitive text.

The filtered tree will display the identified fields, and all tables.

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1643109372391.png)

### See Also

- Default Table Order