Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt: Intellisense

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Partial Name Matching (like the Intellisense in VS2010)

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" I would get a list containing "ClientID".

Try it on Visual Studio 2010 and see what I mean.

This would help immensely in scenarios where column names are made unique.

36 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

AndrewJacksonZA shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminPaul Stephenson (Admin, Redgate) commented  ·   ·  Report

    For those who have tried the partial matching feature, do you like the prefix list to be ordered before the substring matches, or would you rather all the matches to be alphabetically ordered, as suggested by Simon Sabin in a previous comment?

  • AdminPaul Stephenson (Admin, Redgate) commented  ·   ·  Report

    Hi Simon, thanks for your feedback. If you click the the little arrow on the bottom-left of the suggestions window then the schema is displayed. Does this work for you?

  • simon sabin commented  ·   ·  Report

    The feature works nicely but needs to have the schema in the list of objects and the list needs to be sorted by the object name. Currently the prefix list appears before the partial list.

  • Alex Birch commented  ·   ·  Report

    I agree with Brian - we have 200 tables in our DB and using the camel case intellisense would definitely speed up entry.

    give there's a table in the DB called ContainerTypePerson then:

    ssf tab ctp tab

    would expand to SELECT * FROM ContainerTypePerson

  • Jakub Dvorak commented  ·   ·  Report

    SQL Server Denali has this feature in intellisense. I voted to include it in SQL Prompt!

  • Brian commented  ·   ·  Report

    I am in love with camel case intellisense. So "CD" would match "ClientDetails"

  • Anonymous commented  ·   ·  Report

    The free dbForge SQL Complete Express Edition also has this feature: it suggests ALL columns that contains the typed fragment anywhere in its name. SQLPrompt only suggests columns that START with the typed fragment.

  • Darek commented  ·   ·  Report

    I second the Partial Name matchig idea. It would be great to have.

  • AndrewJacksonZA commented  ·   ·  Report

    That last line is supposed to read:
    "This would help immensely in scenarios where column names are made unique throughout the database."

  • AndrewJacksonZA commented  ·   ·  Report

    Err, right, so much for my attempts at code formatting... :-/