About Working with Data

Learn more about Toad for SQL Server
at Dell Software

Find solutions and downloads at the
Toad for SQL Server Support Portal

You are here: Work with Data > About Working with Data

You can display data in either a grid (table containing columns and rows) or card view (using a separate record to display all entries in a row).

Troubleshoot Data

If you cannot edit data, click the red icon in the lower left corner of the grid. You do not need to edit fields in this window. See Edit Data in Read-Only Grids for more information.

By default, autocommit is enabled and any row changes you make are automatically submitted to the database. You can disable this option in Tools | Options | Environment | Grid.

Tips for Working with Data

To...	Do this...
Add or reduce the number of rows initially fetched (default 1000).	Enter the new value in the Number of rows to initially fetch in data tab under Tools \| Options \| Database \| General.
Set the value of a cell to null.	Press CTRL+DELETE.
Add column or group summary values	Right-click the data and select Show \| Summary Footer Panel. Then, right-click the Summary Footer Panel below the column you want to add a summary total to and select an option. If you have grouped columns using the Grouping panel (Show \| Group Panel), you can also add a summary total to grouped records.
Apply a summary function to the data (Sum, Min, Max, Count, Avg).	Right-click below the column you want to apply the summary function (but above the Navigation toolbar) and select an option.
Show or hide columns of data.	Right-click a column heading in the data grid and select Remove This Column or Column Chooser.
Display data in a report, pivot grid, or chart.	Right-click the data and select Send To \| Data Report Designer, Chart Designer, or Pivot Grid.
Display the data in a grid or card view; grid view is useful for viewing summary information at a glance; card view is useful for viewing information in greater detail.	Right-click a record and select Show \| Grid View or Card View.
Compare differences between two data sets. See Compare Differences in Data for more information.	Right-click the data and select Compare To.
View multi-line text in the data grid as one-line text separated by spaces.	Right-click the data and select Show \| Multi-line Text as One-line. When the option is cleared, only the first line of the multi-line text is shown. To see the full text hover a mouse over a data grid or expand it.

To...

Do this...

Add or reduce the number of rows initially fetched (default 1000).

Enter the new value in the Number of rows to initially fetch in data tab under Tools | Options | Database | General.

Set the value of a cell to null.

Press CTRL+DELETE.

Add column or group summary values

Right-click the data and select Show | Summary Footer Panel. Then, right-click the Summary Footer Panel below the column you want to add a summary total to and select an option.

If you have grouped columns using the Grouping panel (Show | Group Panel), you can also add a summary total to grouped records.

Apply a summary function to the data (Sum, Min, Max, Count, Avg).

Right-click below the column you want to apply the summary function (but above the Navigation toolbar) and select an option.

Show or hide columns of data.

Right-click a column heading in the data grid and select Remove This Column or Column Chooser.

Display data in a report, pivot grid, or chart.

Right-click the data and select Send To | Data Report Designer, Chart Designer, or Pivot Grid.

Display the data in a grid or card view; grid view is useful for viewing summary information at a glance; card view is useful for viewing information in greater detail.

Right-click a record and select Show | Grid View or Card View.

Compare differences between two data sets. See Compare Differences in Data for more information.

Right-click the data and select Compare To.

View multi-line text in the data grid as one-line text separated by spaces.

Right-click the data and select Show | Multi-line Text as One-line. When the option is cleared, only the first line of the multi-line text is shown. To see the full text hover a mouse over a data grid or expand it.