View Issue Details

IDProjectCategoryView StatusLast Update
0000994Database Workbench v5Visual Query Builderpublic2017-04-18 13:25
ReporterDinko Bacun Assigned ToMartijn Tonies  
Status closedResolutionfixed 
Fixed in Version5.3.0 
Summary0000994: Ability to generate SQL without schema names
DescriptionI mostly use Oracle. What helped me be more productive (in ver 4 also) was
the Workbench ability to understand the context, the shema one is working
in, so that I could write field names without the schema name. This saves a
lot of time. But once you enter the query builder, it returns the statement
with full shema names (which is the correct thing to do, of course). I often
use query builder, but for simple stuff, like deciding which fields to show,
or joins or such, and later fine tune the statement in the sql editor. It
would help a lot if there was an option to generate the sql statement
without the schema name, even withouth table name (my field names have table
prefix which forces their unequenes in a single schema). I would like to
have the ability to set preferences for shema name and table name generation
in Query Builder Preferences, while having a checkbox on the Query Builder
screen for ful sintax generation when I want to finish the statement
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2014-08-19 09:09 Dinko Bacun New Issue
2014-08-21 09:22 Martijn Tonies Status new => acknowledged
2017-04-04 11:24 Martijn Tonies Assigned To => Martijn Tonies
2017-04-04 11:24 Martijn Tonies Severity minor => feature
2017-04-04 11:24 Martijn Tonies Status acknowledged => assigned
2017-04-04 11:24 Martijn Tonies Summary Feature request => Ability to generate SQL without schema names
2017-04-04 13:33 Martijn Tonies Status assigned => resolved
2017-04-04 13:33 Martijn Tonies Fixed in Version => 5.3.0
2017-04-04 13:33 Martijn Tonies Resolution open => fixed
2017-04-18 13:25 Martijn Tonies Status resolved => closed