Start Query based insertion or updating of blob values

Query based insertion or updating of blob values

The graphical image of each table includes compartments you can expand to view in greater detail or collapse so you can concentrate on table relationships, which are clearly indicated with connecting lines.

Numerous customization options are available for each chart type, including chart titles, foreground and background colors, definition of axis ranges and labels, control of fonts, text colors, fonts and sizes, and more.

Intuitive dialogs let you specify every element of a chart, even the tilt angle for 3D pie charts.

Now you can create attractive and informative charts data visualization of information in your database without exporting data to a dedicated charting application.

Charts created using Database Spy are customizable to suit business intelligence reports in HTML, Microsoft Word, RTF, or PDF documents, or you can save charts created in Database Spy in your choice of .png, .bmp, .gif, or image formats at the custom resolution you specify.

Then automatically regenerate the report with updated data any time it’s needed.

Information stored in relational databases is rarely static.

When a database administrator needs to recreate a complete database structure, scripts are required not just to create tables, but also all views, constraints, indexes, functions, procedures, etc. DDL Scripts are essential for backing up complete database structures, or to move a structure to a different server when the actual table contents are not required, such as moving from a development environment into production.

A colorful, eye-catching chart is much more vivid and communicates meaning more effectively than a table of numeric data.

You can select a range of cells and copy them to paste into another application, print the results table, or automatically calculate and display information about selected results.

You can also sort the results by any column to display the table data in a more useful form.

This query could be much more flexible by replacing the product name ‘sprockets’ and the customer number 525 with parameters, as shown in the second query window above where the parameters :pname and :custnum are substituted for the product and customer.