Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any database and write it. Support ORACLE, MS-SQL server 6.5-7.0-2000, MySQL,SyBase,Teradata, Db2 for NT, MSAccess and other ODBC databases.
Allow update selected data.
Union query builder.
OLAP inside.
Make Table SQL-query builder.
Delete query builder.
Export of the data of Query to files of various formats.
Feature of the given program is the opportunity of creation of query to diverse sources of the information, for example, to ORACLE and SYBASE simultaneously. Besides it is possible quickly and visually to create query with calculated fields in view of specificity of language of queries of a separate database. There is an opportunity of preservation of the created query as representation (VIEW) in a database for its further use.
Load external SQL-query (reverse engineering).
Show result sets in Print Preview by page and print on selected printer.
Union query builder.
Extract DDL scripot for some database objects.
Show stored procedures from database and its parameters. Stored Procedure execute wizard.
The inclusion of OLAP functionality within Visual SQL-Designer helps make multidimensional analysis more affordable and brings the benefits of OLAP to a wider audience. Analyse external cube files and create Your own cube files from various database sources.