Offer table/col name suggestions based on partial strings

kevrileykevriley Preston, UKPosts: 129 Gold 1
edited December 6, 2011 7:32AM in SQL Prompt Previous Versions
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.

Comments

Sign In or Register to comment.