Offer table/col name suggestions based on partial strings

kevriley

I know this has probably been mentioned before, but I couldn't find it in the forums.

I'm working with a database where the column names are prefixed with 2 letters, an underscore, 2 more letters signifying the table and then another underscore. So for example the table XX_CLIENT has columns

XX_CL_FORENAME
XX_CL_SURNAME
XX_CL_EMAIL
XX_CL_ADDRESS1
XX_CL_ADDRESS2
XX_CL_POSTCODE

etc.....

Using SQL Prompt to suggest column names, I would like to be able to start typing 'ADD' and have the 2 columns with ADD in them be suggested. Otherwise I'm having to type the useless prefix 'XX_CL_' to then get a list of useful suggestions.

kevriley

DOH!

Just found it at http://redgate.uservoice.com/forums/94413-sql-prompt-feature-suggestions/suggestions/1374959-partial-name-matching-like-the-intellisense-in-vs

Anu D

Thanks for your post.

I am glad you found the feature request.