My primary database these days is a legacy mainframe DB2 beast. Table and column names tend to be both terse and obtuse. An example (and easier than most we have) would be a table named PART_EMPL_HIST. We use the designer to rename that as ParticipantEmploymentHistory and we do the same for columns. This works great for coding.
Sometimes we are looking to run an ad-hoc query in an tool such as IBM Data Studio (Yuck, but it's the best that IBM has.) For that, I need the "real" table name. It would be helpful to grab it from the designer but I can't find any way to do it.
I'd like to have some way to copy the real name from the Catalog Explorer, perhaps from the context menu. It would make me really happy if I could generate SQL statements from that context menu, ala SSMS. Select would be enough but I'm sure I'd find a way use DML statements too.