How can we help you today? How can we help you today?

Offer table/col name suggestions based on partial strings

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
0

Comments

2 comments

Sort by

Add comment

Please sign in to leave a comment.