SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Remove automatically aliases from a Query

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Remove automatically aliases from a Query
Author Message
apadilla



Joined: 29 Mar 2012
Posts: 1
Country: Mexico

Post Remove automatically aliases from a Query Reply with quote
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.
Thu Mar 29, 2012 5:43 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Hi, SQL Assistant is not designed to remove aliases from existing scripts.
Thu Mar 29, 2012 5:47 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1401

Post Reply with quote
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 :)
Fri Mar 30, 2012 2:57 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.