Features
SQL Prompt
SQL Prompt supports code-completion, SQL statement expansion (e.g. on INSERT and ALTER PROCEDURE statements), 'SELECT *' automatic expansion to a list of columns, instant schema information viewer and support for SQL snippets to quickly add commonly used SQL.
SQL Doc
Easily write, edit and output database documentation for your databases. Generate HTML documents, printable Word documents or CHM files of your documentation. The documentation supports multiple databases and all internal and cross-database dependencies.
SQL Data Generator
Quickly generate quality test data for your databases that simulates production data. SQL Data Generator intelligently reads your column names and data types to automatically suggest the most appropriate test data for that column, choosing from over 60 built-in data generators. Quickly generate names, addresses, phone numbers, products and more or create your own generators. With foreign key support for generating consistent data across tables, automatic data conversion and command line support, SQL Data Generator provides a powerful solution for generating test data.
SQL Refactor
SQL Refactor includes 11 refactorings to improve your SQL. Improve the readability and maintainability of your SQL scripts and database objects by automatically formatting them in a standard style - the SQL layout functionality contains over 30 options to suit the formatting style your company has adopted. Use Smart Rename to rename tables, views, stored procedures and user-defined functions and automatically update all references to these objects. Encapsulate a selection of code and convert it into a stored procedure, split a table into two and automatically update all references, summarise scripts to get a concise overview of their action, find unused variables and parameters, and more. Please note: SQL Refactor is an add-in to SQL Server Management Studio.