Option to include the schema when generating an alias.
I have tables that repeat in different schemas, for example Supplier.Location and Customer.Location. I'd really like auto-alias to include the schema when generating the alias. Supplier.Location should be SL and Customer.Location should be CL. Instead I end up with L and L2, which is not as clear.
Ideally, I'd prefer the schema characters to be lowercase and the table to be uppercase. Using sL and cL would make my query even more readable.
Wes
shared this idea
-
Eugene Niemand
commented
The dialog to create asks for object name. I thought object name always includes schema. It seems like this is not the case.
-
Leighton Gosnell
commented
Bump bump! This feature would be awesome to see. I too am suffering with the custom alias functionality not supporting Schemas.
Personally I would rather not have them be lowercase only, but understand this is a coding preference.
-
Bill Cunnien
commented
@Bangås -- custom aliases recognizing schemas is exactly what I am looking for ... what a great help this would be!
-
Ole Kristian Velstadbråten Bangås
commented
Personally, I would like the alias to be lower case only, but that could very well be an option. I would also add, that it should be possible to add custom aliases for combination of schema and object, that alone would have been sufficient for me.