---
title: "Database Tools"
canonical: "https://help.innovyze.com/space/infoassetplanner/15794300/Database%20Tools"
format: markdown
---
The DB Editor contains many tools to assist you in manipulating their data.  These tools are described below.

---

**Block Editing: **By highlighting a number of cells in a column and right-clicking, you can quickly block edit multiple cells at once.

> Macro (inline-media-image)

> Macro (inline-media-image)




In addition to block editing and the copy/paste tool (not a right-click option, only with hot keys, i.e., CTRL- V) available within the DB Editor, there are also tools available when right-clicking a field title.

![image](media://5285f3da-0a66-420c-9fb2-e4292fa40580)

**Sort Options: **You can sort by particular field in either alphabetical or numerical order.  Multi-field sorting is also available by using this option on multiple fields.

**Best Fit: **Formats column width.

**Filter Mode: **When applicable, this option will appear to allow you to view data with an ArcMap domain applied or without.

**Field Statistics: **When applicable to the field selected, this option will appear.  It summarizes the numerical data in the column.

**Field Calculator: **This tool is very similar to ArcMap's Field Calculator function.  You can create equations or relationships to manipulate data based on values found in other fields.

![image](media://5c7a45ff-8169-4616-a004-b98d3af4ed07)