Visual SQL-Designer is a program for easy visual constructing hard SQL-query for any Banque de données 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 Langue of queries of a separate Banque de données. There is an opportunity of preservation of the created query as representation (VIEW) in a Banque de données 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 Banque de données objects.
Show stored procedures from Banque de données 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 Banque de données sources.