Quick Check of SQL Table Contents With Data Visualizers
Tags: sql, database, visualization, sqlserver
Published: 2020-05-07 15:30:28

Visualize your SQL data to facilitate understanding and decision making with the **Data Visualizers** feature of SQL Complete. On many occasions, developers and DBAs need to quickly check the table contents and getting data in a readable format without much effort becomes a matter of importance.

[SQL Complete](https://www.devart.com/dbforge/sql/sqlcomplete/) users can benefit from the opportunity to view the cell contents in the required format right in the Results grid whenever necessary. The tool takes the pain out of checking and analyzing tables with multi-format data.

The **Data visualizers** feature that is tailored to suit the needs of the most demanding SQL developers allows viewing data in 9 common data formats: Hexadecimal, Text, XML, HTML, Rich Text, PDF, JSON, Image, and Spatial. To start working with Data Visualizers, you should just output the required data to Results Grid and then switch to Data Viewer.

![Data visualizers](https://dev-to-uploads.s3.amazonaws.com/i/6q70dvw1ly3weczf7ew3.png)

#Image view
The Image View option allows viewing database image contents right in the Results Grid which significantly saves your time and efforts. To enable the Image View, click the corresponding icon on the toolbar.

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/9omv5fwo7nzt0z91pb1z.png)

#Viewing data in the hexadecimal format
In case you need to view the cell values in the hexadecimal data format, click the Hexadecimal View button in the Data Viewer and Editor toolbar and enjoy the quick result.

![hexadecimal format](https://dev-to-uploads.s3.amazonaws.com/i/bf265g5k9a1wmcn9u1xl.png)

#Viewing data in the Text format
To display the table data in the Text format, use the Text View option. It might be very helpful when working with tables that contain long descriptions and text data.

![Text format](https://dev-to-uploads.s3.amazonaws.com/i/dnb9m3bavuw2cfiap8pl.png)

#Viewing data in the XML format
XML View is designed to show the cell contents in a popular XML format. Just click the button and see the result.

![XML format](https://dev-to-uploads.s3.amazonaws.com/i/sjna3g66jnymurrzvxst.png)

#Viewing data in the HTML format
Switching to the HTML View will display the cell contents in the HTML format in a flash.

![HTML format](https://dev-to-uploads.s3.amazonaws.com/i/0hxkxoy50391juf3o701.png)

#Viewing data in the Rich Text format
The Rich Text View allows viewing contents in the Rich Text format with one click.

![Rich Text format](https://dev-to-uploads.s3.amazonaws.com/i/tm7s3iwnj7x5bcrwzahy.png)

#Viewing data in the PDF format
With the help of Data Viewer, you can quickly view a PDF document just by selecting the PDF View option and then positioning the mouse pointer over the value in the grid.

![PDF format](https://dev-to-uploads.s3.amazonaws.com/i/kxg57aljh9g6c3zglsir.png)

#Viewing data in the JSON format
To view the data in the JSON format, click the JSON View button on the Data Viewer and Editor toolbar.

![JSON format](https://dev-to-uploads.s3.amazonaws.com/i/52n299f9xr7m6mv9p5av.png)

#Spatial view
You can now view data representing spatial values much easier than ever before.

![Spatial view](https://dev-to-uploads.s3.amazonaws.com/i/itabftbvsjjcqyobtfef.png)

#Saving cell contents to a file
Having viewed the cell contents in the format you’ve chosen, you can then save it to a file and SQL Complete will automatically suggest you save it in the format you’ve worked with.

![Saving cell](https://dev-to-uploads.s3.amazonaws.com/i/kvbik2ts47gncbit8ws0.png)

With the kind permission of Devart. Originally published at https://blog.devart.com/get-the-most-from-your-data-with-sql-complete.html