Skip to content
← Customer Feedback for Devart

SQL Complete

dbForge SQL Complete is an intellisense add-in for SQL Server Management Studio and Visual Studio with advanced autocompletion and formatting features of T-SQL code.

To consider your idea as soon as possible, follow the guidelines:
  • Describe the goal you want to achieve and what result you want to get
  • If you have a solution, add it to the description
  • Give examples that we can use to implement your ideas
  • Add one suggestion per post. If you have several ideas, share them in separate posts
  • Add comments to the suggestion

http://www.devart.com/dbforge/sql/sqlcomplete/

SQL Complete

Categories

JUMP TO ANOTHER FORUM

(thinking…)

How can we improve SQL Complete?

You've used all your votes and won't be able to post a new idea, but you can still search and comment on existing ideas.

There are two ways to get more votes:

  • When an admin closes an idea you've voted on, you'll get your votes back from that idea.
  • You can remove your votes from an open idea you support.
  • To see ideas you have already voted on, select the "My feedback" filter and select "My open ideas".
(thinking…)

Enter your idea and we'll search to see if someone has already suggested it.

If a similar idea already exists, you can support and comment on it.

If it doesn't exist, you can post your idea so others can support it.

Enter your idea and we'll search to see if someone has already suggested it.

275 results found

  1. Provide quick access to the object definition SQL

    E.g. by implementing the command that opens object definition in the new document.

    124 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  10 comments  ·  Admin →

  2. Provide a global rename option of and alias

    Have the ability to right-click or hover over an alias and be able to choose "Rename". By renaming the alias in one place it would automatically rename all other references to the alias in the query.

    For example: I create a table and it get aliased as r1. I then rename it to rnk, which would change the loin reference to rnk right away.

    75 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →

  3. Ability to re-open tabs after reboot or after closing SSMS

    A really cool addition to Sql Complete would be the ability to re-open tabs after a reboot or even after just closing SSMS.

    If you look at good quality text editors such as UltraEdit or even browsers such as Chrome & Firefox, they have the ability to remember which tabs were open.

    64 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →

  4. Save Execution History

    Save a history of your executed SQL statements and allow you to search that history.

    Also save the current session so when you open SSMS you can click a button to open all the queries you has open when you last closed SSMS.

    55 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →

  5. Ability to expand columns when typing UPDATE statements (similar to INSERT)

    1. Let's assume we have a table:

    CREATE TABLE dbo.Employee
    (
    EmployeeID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
    IsMainWorkPlace BIT NOT NULL,
    TabelNumber VARCHAR(6) NULL,
    PersonID INT NOT NULL,
    DepartmentUID UNIQUEIDENTIFIER NOT NULL,
    DateIn DATETIME NOT NULL,
    DateOut DATETIME NULL,
    IsLabourUnionMember BIT NOT NULL,
    FiringReasonID INT NULL
    )

    1. Let's type the following construction and click TAB at the end:

    UPDATE dbo.Employee

    1. Suggest to expand columns just like it's implemented for INSERT:

    UPDATE dbo.Employee

    SET

    IsMainWorkPlace = DEFAULT /* IsMainWorkPlace - BIT NOT NULL /

    , TabelNumber = '' /     TabelNumber - VARCHAR(6) /

    , PersonID = 0 /     PersonID - INT…

    46 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →

  6. Custom Alias Map - Tell SQL Complete to always use a specific alias for specific table

    I have a table (ObjectReference) and Sql Complete maps it to or1. I understand why it adds the 1 to avoid using the "or" keyword, but it would be nice to set up Sql Complete to use a more friendly keyword.

    One solution for this would be to allow me to map table names to alliases. Then, any time ObjectRerence is used, it would get oRef (or whatever) from the map.

    44 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Admin →

  7. Extended Outline - Custom Collapsable Regions (like C#) with Comments

    Introduce Regions like #region in C# for collapsable sections. This regions should have a "name" or comment and should be displayed in document outline for navigation. This has lot of benefits in large sql code files for better orientation and navigation.

    41 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  3 comments  ·  Admin →

  8. Increase indentation in WHERE with nested OR clauses

    In the case where you have a nested (parenthesized) condition, increase the indention after the new line.

    How it currently operates:

    SELECT *
    FROM MyTable
    WHERE
    (a=1
    OR b=2
    OR d=5)
    AND c=3

    This doesn't really convey the fact that this is a subexpression, and it requires tracing the parenthesis with more complex queries. Something like this would be better:

    SELECT *
    FROM MyTable
    WHERE
    (a=1
    OR d=5
    OR b=2)
    AND c=3

    So for each parenthesis level with a different logical operator than the previous level (to help prevent over-indenting when parenthesis are applied too liberally), increase the indention level…

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Admin →

  9. Installer - Give option to ignore message about running applications

    Everytime I upgrade, the installer forces me to exit Visual Studio. However, I only install SQL Complete for Management Studio. Please give me an option to ignore that error message

    35 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  0 comments  ·  Admin →

  10. When autocompleting a column or table name, automatically put brackets around SQL keywords

    When autocompleting a column or table name, if the name is a SQL keyword, automatically place the brackets around the name. For example, the query "SELECT Version FROM Table" is currently auto-corrected to "SELECT VERSION FROM TABLE", which causes an error.

    Instead, it would be nice if SQL Complete auto-corrected to "SELECT [Version] FROM [Table]".

    34 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  4 comments  ·  Admin →

  11. Support SSMS 2016

    Support SSMS 2016 CTP

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Features  ·  Admin →

  12. "Go to definition" feature for procedures, views, etc.

    When there's a valid sql object under the cursor in the text editor, two nice features (via context menu):

    1. Go to definition (select in object explorer)
    2. Script object (clipboard, new window, etc...)

    Also object names should be shown as a link if the Ctrl key in pressed. All object names in script shows as hyperlink. Ctrl+click or Ctrl+Enter on it opens the object definition in new tab.

    33 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →

  13. Format table and field names to be consistent with the database letter case

    When formatting a statement:

    SELECT sometable.fieldname AS something FROM sometable

    SQL Complete KNOWS the proper case of the table and field names (as it allows you to autocomplete them as you're typing it in). So, why doesn't it alter the case of them once they're already in the statement?

    If the table was actually SomeTable in the database, and the field was called FieldName, the "format" function should fix the statement like so:

    SELECT SomeTable.Fieldname AS something FROM SomeTable

    32 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  5 comments  ·  Admin →

  14. Allow Table Aliases to be Uppercase without affecting the Table/View name case

    I tried changing the Identifier to Uppercase to try to get the Table aliases to be uppercase but that made the tablename uppercase as well.

    30 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    2 comments  ·  Admin →

  15. Intellisense on Temp Tables and Table Variables

    Show the table columns in the Intellisense when you create temp tables or declare table variables.

    29 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    1 comment  ·  Admin →

  16. Options -> Settings -> Qualify column name -> **enclose with []

    It would be a nice feature if you can add to database, schema and table brackets []. If you use certain characters like $ you have to enclose it with [].

    28 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    5 comments  ·  Admin →
    completed  ·  AdminDevart (_, Devart) responded

    It’s implemented in the latest build of SQL Complete. Have a look at the “Enclose identifiers within square brackets” option.

  17. Stored Proc Expansion

    27 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  9 comments  ·  Admin →

  18. Make Format Selection to format what is actually selected

    the format selection does expand the actual selection. Sometimes this is nice as it expands to include other bits that should have been selected but haven't other times it selects more than I want formatted. I think it should really only format what I actually select. Perhaps another option for format selection and related could be added too?

    26 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Admin →

  19. Right Align of keywords

    Right alignment of keywords is an important formatting option.

    25 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    4 comments  ·  Admin →

  20. Separate formatting for subquery

    It would be very nice to have options for separate formatting for subquery, for example:

    SELECT
    OrderID,
    OrderName,
    OrderDate
    FROM Orders
    WHERE ClientID = (SELECT ClientID FROM Clients WHERE ClientCode = 'ABC')

    Here, I need the main SELECT to be stacked and formatted appropriately, and subquery SELECT - to be wrapped and in one line).

    In large and complex SQL script this feature is invaluable.

    Currently it is not possible - one format is applied for everything.

    Thanks.

    24 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    completed  ·  2 comments  ·  Admin →
← Previous 1 3 4 5 … 13 14
  • Don't see your idea?