DataGrip - Ignore Database Table Prefix when creating aliases?

Answered

I have a database which uses a prefix ("wp_") on all of the table names.  When I'm writing queries I usually exclude the prefix letter when making an alias (IE: `wp_users u` rather than `wp_users wu`).  However, when I'm using Datagrip's otherwise excellent auto-completion, it always wants to use the `w`.

Is there a way to tell DataGrip to ignore the prefix when creating aliases?

0
4 comments

I ran into the same issue.  What I did was set up an alias in the code completion.

0

I'm not sure I understand.  Are you saying that you manually created aliases for all of your tables using the Custom Alieases feature?

0

Yes, well only for the ones that I use most often.

2

Rex Schrader,

Jim Gust offered the right solution for you question. Use `Custom aliases`

-1

Please sign in to leave a comment.