Viewing the Database Catalog

Viewing the database catalog is very useful when writing SQL statements. WinSQL Professional displays this information in a hierarchical format, depicted as follows:

Note: The following illustration is in Classic View.

 

 

The objects in the Catalog Details window are divided into two categories:

·Common objects to all databases

·RDBMS specific object

The first category is available for all databases and is available in all editions of WinSQL Professional. However, the second category is only available in WinSQL Professional, and the contents depend upon the back-end database.

Notes:

·The screen shot above displays a connection to MS-SQL Server and contains the database-specific features you see if the database type is MS-SQL Server.

·Catalog information depends heavily on the capability of the ODBC driver. WinSQL Professional queries these drivers and determines which information is available. For example, the CLI drivers associated with the Informix client setup cannot display the parameters for a stored procedure.