ApexSQL Refactor is described as 'SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables. It expands wildcard, fully qualifies object names, renames SQL database objects'. There are three alternatives to ApexSQL Refactor for Windows, SQL Server Management Studio and Microsoft Visual Studio. The best alternative is dbForge SQL Complete. Other great apps like ApexSQL Refactor are SQL Prompt (Paid) and Sql Assist (Paid).
dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and paid editions of the tool offer the powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.