310 results found
-
Collation names enclosed in square brackets is invalid
I have "Enclose identifiers within square bracket" set to "Always", which in most cases are great.
However, collation names are also being enclosed in square brackets, which seems to be invalid.
Please correct.1 vote
AdminPMs
(Admin, Devart)
responded
Could you please specify what product version you are using?
A video or screenshots would be also of help.
-
Add an option to show/hide or find columns in the Results pane
It will be very helpful if you have an option to Show/Hide the columns in the Result Set and also an option to search the columnname.
6 votes -
Specify Schema Text Case
In my database named "IDS", I have a schema named "ids".
I would like to specify that the schema be lower case when formatting.This is what currently happens.
When I format something like this:
select * from IDS.ids.Location l;It is formatted to:
SELECT * FROM IDS.IDS.Location l;I would like to specify that the schema be lower case:
SELECT * FROM IDS.ids.Location l;1 vote -
Alphabetical listing when creating a SELECT list
Allow for an alphabetical listing when creating a SELECT list? It makes it difficult to quickly check the checkboxes when quickly adding columns.
7 votes -
Notifications pane
Currently SQL Complete notification (like "Uncommitted transaction" and "Query execution completed") show up and disappear. It would be great to have them on a panel similar to "Document Sessions", so you can review them later.
1 vote -
Display a single row of data in column format
As per Oracle SQL Developer ability to select a row of data and have it displayed in a column. Makes viewing a large row of data a lot easier.
1 vote -
Configure Order Code Completion by schema
Order code completion by schema. Currently it orders alphabetical by table name.
Lets say you have the following schema.tables :
main.fullfillmentaddress
staging.contactaddress
history.directrelatedaddressIf I type in the following
select * from address
(the code completion will suggest in this order):
staging.contactaddress
history.directrelatedaddress
main.fullfillmentaddressI'd prefer main to always be the first schema returned. Not a big deal when you only have a few tables but we have hundreds.
1 vote -
1 vote
-
Table alias gets converted to uppercase
When using a table alias of "u", all new instances becoming capitalized incorrectly.
Please see attached gif:
https://ibb.co/fr9LcH12 votes -
Popup 'select top 100'
I often find when writing queries in the Sql editor that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
1 vote
AdminDevart
(_, Devart)
responded
You could use the snippets functionality of dbForge SQL Complete.
The snippet can be as follows:
SELECT TOP $count$ *
FROM $schema$.$table_name$ -
I often find when writing queries that I want to see a sample of data from the table I'm working with. It would by good if I could right cli
I often find when writing queries in the SQL edior that I want to see a sample of data from the table I'm working with. It would by good if I could right click on the table name in the text editor and have a 'select top 100' option in the popup menu
0 votes -
Combine views and tables in suggestion list as a single sorted list. Add a setting to enable this.
I would like to see the list of tables and views as a single sorted list in the suggestion list instead of tables then views. Add an option in Preferences to enable this feature for those who want it.
1 vote -
SQL Operations Studio Support
Microsoft Introduced a new Query tool: SQL Operations Studio
I wonder if you would be able to build a support for that tool?
4 votes -
Search in Unsaved file (from Document Sessions)
We currently have an ability to search through executed queries. It would be great to be able to search in unsaved (and saved as well) files which are available in Document sessions.
Here is a use case for this. Let say you wrote a script, but you only executed part of it. There is no way to find the full script in the Execution history even though the full file is available in Document Sessions. So you would have to active document sessions which may have a large number of files, but you need only one of them.
Ability to…
1 vote -
Document Sessions Improvements Phase 2
Thank you for implementing enhancements to the document sessions. It looks great and adds much more value. I would like to suggest couple more enhancements:
- It would be more convenient if more recent sessions would be on the top instead of the bottom
- Apply connection coloring to the document sessions. So each file name would have a background color of the connection. It would make the 2 features integrated and extremely useful.
- Have a setting to remove old sessions older than 2 months (or period specified by users)
- Fix Display connection details next to each file (as you do in…
9 votes -
De-couple execute-current-statement functionality from code completion.
I like execute-current-statement functionality, but when I disable code completion then execute-current-statement functionality stops working.
3 votes -
Execute current statement with variables
When running a query via "Execute Current Statement", it doesn't run if there are variables referenced. Instead you have to highlight the variable + query to get it to run. It would be nice if the variables were automatically included in the execution
1 vote -
2 votes
-
SQL Complete (or at least formatter) for Firebird?
Could you expand the SQL syntax to allow SQL code formatting for Firebird SQL?
1 vote -
Add option to adjust function tooltip font size
The tooltip font is just too small ...
4 votes
- Don't see your idea?