SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Auto Add Aliases

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Auto Add Aliases
Author Message
neverden



Joined: 02 Dec 2008
Posts: 58

Post Auto Add Aliases Reply with quote
I love the "Auto Add Aliases" feature. It works great. However, there are some tables I was to change the default. For example, If I have a table named OrderHeader it will use OH. Is there anyway to change just that table to use O ?
Fri Oct 02, 2009 8:48 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7847

Post Reply with quote
I'm afraid this is not customizable.

Just in case, the logic for generating aliases is the following:
If a name is case sensitive, pick capital letters and use them together.
If a name is not case-sensitive but contains underscores or spaces, pick first letters of each word.
Otherwise just pick the first letter.
If the generated alias is already used, add unique number to the end.

As you can see, to make it generate "o" alias instead of "oh", you would need to rename "OrderHeader" to "orderheader" which I don't think you would wont to do.
Fri Oct 02, 2009 9:44 am View user's profile Send private message
neverden



Joined: 02 Dec 2008
Posts: 58

Post Reply with quote
Thanks! That would be a nice feature to add!
Mon Oct 05, 2009 9:06 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.