Skip to content

SQL Prompt

Welcome to the SQL Prompt feature suggestion list. Find out more information about SQL Prompt at http://www.red-gate.com/products/sql-development/sql-prompt/.

If you have any questions, need help or have found a bug in SQL Prompt, please visit the forums or our support portal.

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

63 results found

  1. I would like to suggest a ranking feature when the suggestions list appears. At my place of work, if I want to select out of the customer table I will often type 'cu' then tab the rest. However this is the snippet for creating a user. This is also useful when many tables begin with the same prefix, but one is used far more often than others. With ranking, the more an object is used, the higher up the list it will appear, like browser history entries in Firefox for instance. This would reduce the number of keystrokes necessary and…

    70 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  2. I thought that partial matching for Intellisense was a rubbish idea, but after using in VS2010 I find it absolutely indispensable, and I really miss it in SQL Prompt.

    [b]What is it?[/b]
    An example:
    [code]
    CREATE TABLE [dbo].[Clients](
    [ClientID] [int] NOT NULL,
    [ClientName] [varchar](50) NOT NULL,
    [ClientSurname] [varchar](50) NOT NULL,
    [ClientCardNumber] [int] NOT NULL
    ) ON [PRIMARY]
    [/code]

    If I had to now type
    [code]
    SELECT
    ClientID,
    ClientName,
    ClientSurname,
    ClientCardNumber
    FROM
    dbo.Clients AS c
    ORDER BY
    $CURSOR$
    [/code]
    and started typing "Cli" I would get a list of all the column names on the table. However, if I typed "ID"…

    36 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

  3. I found several feature requests concerning synonym support on the Red Gate forums: It was always put on the feature request list, but SQL Prompt still lacks support for synonyms.
    Explanation: Synonym resolution support is crucial for us, since our database design and development strategy completely relies on them. We use synonyms for everything that is out of current database context. So we develop as if every used object was within current database. It's annoying to type an object name that is in fact a synonym - and SQL Prompt does not display auto-completion for the object itself nor for…

    102 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    completed  ·  Aaron Law responded

    We’ve released SQL Prompt 6 which includes full synonym support.

1 2 4 Next →
  • Don't see your idea?