SQL Server Query Analyzer

Definition of SQL Server Query Analyzer in The Network Encyclopedia.

SQL Server Query Analyzer

A graphical user interface (GUI) for creating and testing Structured Query Language (SQL) statements and scripts in Microsoft SQL Server 7. This tool corresponds to the ISQL_w tool in version 6 of SQL Server.

How It Works

SQL Server Query Analyzer includes a free-form text editor that you can use to create SQL statements and scripts, with syntax-dependent color-coding to improve readability. You can display the results of executing a SQL query in a window as free-form text or as a grid. SQL Query Analyzer can also use SHOWPLAN to graphically display the flow of logic in a query. You can use the Index Tuning Wizard to determine whether adding more indexes will improve query performance. You can start SQL Server Query Analyzer from SQL Server Enterprise Manager.