Unless I’m mistaken, the current version of Toad (including 6.0 beta) doesn’t support the following and I’d really like it added.
Consider the following:
Select EmployeeFirstName, EmployeeLastName From DimEmployee
I’d like the ability to automatically alias the table. For example, DimEmployee could become DE. Another competing product already offers this:
Suppose I choose to now add one or change an existing alias that I don’t like.
Select EmployeeFirstName, EmployeeLastName From DimEmployee as DE
Why can’t Toad go back through my query and properly update the query to add “DE.” in front of the selected items from that table?
These are pet peeves of mine which cost me time every single day.
- This goes along with the previous requests, but now let’s add a joined table to it. If I allow the auto-complete to pull in the FK relationship I get the following:
Select DE.EmployeeFirstName, DE.EmployeeLastName From DimEmployee as DE
join dbo.FactOrders ON dbo.FactOrders.SalesRepKey = DE.EmployeeKey
Now I have to manually alias dbo.FactOrders as FO and fix the ON clause.
There’s got to be a better way to handle this.