View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000994 | Database Workbench v5 | Visual Query Builder | public | 2014-08-19 09:09 | 2017-04-18 13:25 |
| Reporter | Dinko Bacun | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | feature | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 5.3.0 | ||||
| Summary | 0000994: Ability to generate SQL without schema names | ||||
| Description | I 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 | ||||
| Tags | No tags attached. | ||||
| 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 |
