The SQL Wizard, available in WinSQL Professional, allows you to create SQL queries with the help of a wizard, rather than creating queries by entering code. It allows you to select the desired tables and fields, and to apply filter conditions, before creating the SQL code for you.
The SQL Wizard determines the referential integrity constraints specified against any table and draw appropriate relationships.
Note: WinSQL Professional may not be able to determine referential integrity constraints in certain case where the ODBC driver does not provide necessary information, such as drivers for Microsoft Access.
To activate the SQL Wizard, point to the Tools menu, and then click SQL Query Wizard.