Group Databases and Database Objects New!

This feature enables to create custom folders for databases, stored procedures, views, functions and tables. You can organize your SQL objects in logical modules which are aligned with your project structure and forget of having hundreds of them within one Management Studio node. More...

SQL Query History New!

This feature allows you to find queries that you are ever run. More...

Refactoring «Rename»

This refactoring method provides an easy way to rename existing object in your database and automatically find and correct the dependent database code, such as dependent tables, views, procedures, functions, triggers, etc More...

View Dependencies

The «View Dependencies» is a powerful utility that can be used to quickly find database object dependencies. More...

Find Code

The «Find Code» is a powerful utility that can be used to quickly find SQL code in all database object type. More...

Displaying calculations on the SSMS status bar

For a quick look at totals of cells that are selected in your query results page, take a look at the SSMS status bar. On the status bar, SQL Refactor Studio displays the sum/avg/count of selected cells that contain numeric data. The sum value on the status bar updates as quickly as you can select or deselect cells. More...

Refactoring «Add CRUD Methods»

Introduce five stored procedures (methods) to implement the creation, retrieval, update, and deletion (CRUD) of the data representing a business entity. More...

Refactoring «Introduce Trigger for History»

Introduce a new trigger to capture data changes for historical or audit purposes. More...

Refactoring «Add Lookup Table»

Create a lookup table for an existing column. More...

Refactoring «Move Columns»

Migrate table columns, with all of its data, to another existing table. More...

Find Data

Quickly find data in SQL tables and views. More...

Generate Select Statement

The fastest way to transfer data from an external source (e.g. MS Excel, MS Access) into the MS SQL Server database. More...

Script Table Data

The fastest way to get script of data of the table! More...

Change collation of table columns

The fastest method to fix error “Can not resolve collation conflict...“ More...

Highlight all occurrences of selected word

This feature will highlight all occurrences of a selected with a mouse or keyboard word in the current document. More...

Scripting an object as ALTER

Quickly get script of the focused object in SQL Query Editor. More...

Get row count

The fastest way to get table (view) rows count! More...

Get Top(N) rows

The fastest way to get table (view) data! More...

Generate C# classes New

This feature allows you to generate simple C# classes based on tables. More...