472 results found
-
Stop using database name while drag and drop
when i drag&drop a table to an edit tab, i always get the database with it, like:
SELECT
*
FROM mydatabase.usersbut i want
SELECT
*
FROM usersvery often i use the sql in my code, so i always have to remove the database names
from all the selects, thats very annoying,1 vote -
set aliases for tables once and use in all sql scripts from then on
I would love to be able to right click on a table and set an alias for that table that would then be used in the alias for scripts from then on rather than having to edit them each time
for egmystupidclient_table
i could set an alias of stupidClient to it
so when I typed
select from mystupidclient_table
autocomplete would use the alias for the table i previously specified to give
select from mystupidclient_table stupidClient
ideally we could autocomplete on the specified aliases with a seperate hotkey, tab vs ctrl->space perhaps where one…
4 votes -
Don't show a dialog every time a search/replace occured!
This would increases editing speed...
3 votes -
25 votes
-
code completion of correlated subqueries and where exists ( .. )
Hi
Love DbForge but I find I'm always writing this sort of queryUPDATE
client
SET
client.foo = 0
WHERE EXISTS
(
SELECT
1
FROM
clientRegion
WHERE
clientRegion.clientId = client.id AND ....
)
it would be ideal if dbforge could recommend some completions for the correlated portion inside the ( ) based on fk's in the same way it does for joins.1 vote -
Display in output window when query started
If it is not possible to display how long current set of queries is being executing (in a status bar next to word "Executing..." - I don't see quite honest why it is not possible), how about to show start time in an output window saying when query was sent to execution. Right now it shows only AFTER query has returned a result which is some what becomes irrelevant.
I come from MS SQL and it is handy to know how long any query is executing without profiling it.
6 votes -
Ability to replace selected snippet fragments using drag'n'drop
When using code snippets, make it possible to replace selected fragments using a usual drag'n'drop without the need to manually delete them.
0 votes -
Add semicolon at the end of a statement in SQL Log
Would be nice that all statements would be ";" terminated in logging in SQL log so I could copy paste execute a bunch of them on another database to replicate my changes.
0 votes -
Make constructor understand variable with no @
Make the constructor understand a variable with no @
Currently, the constructor doesn't understand a variable having not specified @, so you need to add it manually.0 votes -
Slow Query Log and General Query Log
Make it similar to query analyzer in MONyog.
0 votes -
0 votes
-
Recognising parameters in 'design SQL' mode
When editing a stored procedure, the 'design SQL' mode is very useful to visualise and modify the design of the statement - except when the stored procedure contains a parameter. 'Design SQL' does not recognise the parameter for what it is and instead tries to interpret as a reserved SQL word and kicks out an 'unknown identifier' error. Would be great if the 'design SQL' editor would recognise the parameters and not kick out the error.
1 vote -
check fields exists
Deep sysntax check of stored procedures/functions.
1. Check all variables defined (error, blocks save)
2. Check all defined variables used in code (notice, not blocks save)
3. Check fields exists in tables
4. Etc. Check list can be extended in future.3 votes -
Smart explain integration
Advices to use indexes in queries
2 votes -
Option to rename constraints (PK, FK, indexes, etc) when renaming tables
dbForge Studio creates foreign keys and other constraints using the table name as a prefix. When we rename tables, the foreign keys remain using the old names, which most of the times we forget to change.
It would be great if when renaming a table, there was an option or a question like "Do you want to rename all constraints too?".
This would basically drop any constraint and recreate them using the new names.
This shouldn't be mandatory, but it would be a great feature for early stages of database design, where you tend to rename and move things around…
11 votes -
Generate cleaner SQL
It would be really nice if dbForgeStudio generated cleaner SQL code. Currently, the code generated by dbForge is very confusing and differs too much from the code generated by hand. There is no option to turn some settings off.
This is a problem if we need to maintain SQL scripts that are manually edited later. Everytime we need to export a script, we need to manually format the code and remove all the unecessary stuff.
Some of the issues are:
1) Every identifier is escaped even if it is plain english text. View generation gets really confusing by escaping every…
4 votes -
Center column headings in Excel export as part of template
The current column headings are left aligned by default, usually they are supposed to be centered
3 votes -
Program to parse and analyze mysql_slow.log file
Unfortunately, as far as I understand, there is no such tool with the appropriate GUI, tables, charts, etc.
So you have a great opportunity to implement this.
9 votes -
Add alternative ways to open table and ability to open many instances of same table
Please add a switch key (SHIFT, CTRL or ALT) to the left mouse click behavior to open a table in design, text or data view with a single click.
Also please give the ability to open many istance of the same table in data view to be able to apply different conditions in the Filter Editor for the same table.0 votes -
Filter Editor with selectable conditions
It would be wonderful if you could activate or deactivate each condition in the Filter Editor like in the Navicat "Filter Wizard".
PS: about the "Filter Editor" interface, I don't understand why there is no button in the toolbar to open it...3 votes
- Don't see your idea?