Remove automatically aliases from a Query

Hi,
I want to know if is there any option in your software to remove the aliases from a query, I have many query's that have a lot of table and columns aliases and is difficult to read and understand them, then I'm looking for a tool that help me to change the aliases to the original table and column names.

Any help is welcome!

Thanks in advance!
Alex.

Hi, SQL Assistant is not designed to remove aliases from existing scripts.

I doubt you'll find anything designed for that but it could be done with a regexp search & replace. Although the expression might be quite complicated to cover each and every possibilities of alias forms, it would be reusable. Also, with PATINDEX it isn't very hard to create a snippet that executes it on a stored procedure or a view or even on an arbitrary query, meaning that while SA is not a tool designed to remove aliases from existing scripts, it can be easily turned into one. This versatility is why I like it so much :)