ApexSQL Complete supports table and view aliases in SQL statements. If Auto-generate aliases option is selected, ApexSQL Complete will add automatically created aliases to tables and views.
In the example below the alias adr is assigned to the Person.Address table. Aliases can be defined for all databases on all SQL Servers, all databases on a specific SQL Server or just for a specific database
If global alias is specified for the table/view, it will be inserted instead of the automatically created alias
Where clause automatically lists alias columns
Copyright © 2012 ApexSQL LLC. All Rights Reserved.