SQL Analyzer Professional free download, SQL Analyzer Professional download on software download

The SQL Analyzer application was designed to be a small utility for developers working with SQL Server. It is a stand-alone windows application that can be used to connect to a SQL Server and analyze various database objects in the server. Main features: Connects to different versions of SQL Server like 7.0, 2000, 2005, etc. and different editions like Express, Standard, Enterprise, etc. Once connected, lists out different database objects like Tables, Views, Stored Procedures and User Defined Functions in different panes enabling a quicker search and with following additional features: Tables Lists column properties (name, type, length, nullable, identity, default value, etc.) Marks Primary Keys, Unique Keys, Foreign Keys Lists data in a grid where it can be sorted by columns Lists Referring and Referred tables Lists triggers and other dependent objects Generates SQL scripts for Insert, Update, Delete, Select and Create Exports data in the table as Insert SQL statements Views Displays the data in a grid where it can be sorted by columns Displays the content text of the view Stored Procedures Displays the parameters and its properties Displays the content text of the stored procedure Generates VB and SQL codes to execute a stored procedure User Defined Functions Displays the parameters and its properties Displays the content text of the User Defined Functions Provides a basic query window for execution of SQL statements. Provides Search inside db objects. This feature can be used to search for a text (like table name or an author name) that appears inside a stored procedure, view or user defined functions. Generates Excel reports of database objects with details of table properties. Easy backup and restore options Compares database objects with objects in another database.

SQL Analyzer Professional Related Software