Available Wizards

The following table describes some of the wizards available in WinSQL Professional:

 

Wizard Name

Description

Create New Index

This wizard is invoked by selecting Create New Index from the drop down menu after clicking Admin Tasks. Although this option is available for most data sources, some back-end sources, for example, TEXT driver, may not support it.

Plug-in enabled databases, such as Oracle, MS-SQL Server, DB2, Sybase, Informix, Mimer, PostgreSQL, MySQL and others use a database-specific syntax for CREATE INDEX and support extensions that are not available in other RDBMS. For example, if you are connected to an MS-SQL Server database, you can create a CLUSTERED index.

Rebuild Index

This wizard is invoked by selecting Rebuild Index from the menu when an index is selected.

You can only rebuild an index if it is NOT associated with a primary key. Rebuilding any index requires dropping and recreating the same index again. Most RDBMS do not allow dropping an index if it is associated with a primary key.

Generating DDL scripts

WinSQL Professional allows you to generate DDL scripts for tables, views, triggers and stored procedures. You can either select one object at a time, or you can use the DDL Scripting wizard to selectively pick the object.

To pick one table at a time, select the table from Catalog Details window, and then click Generate CREATE TABLE Statement.

To use the DDL Scripting wizard, point to the Tools menu, and then click Generate DDL Scripts. Select the desired type of objects from this window, specify a file name where the script will be saved, and click Start.