What are the challenges you face when working across database platforms? Take the survey
Options

Omit a specific table from auto-complete

HWI_MikeHWI_Mike Posts: 1 New member
We have a table named "Payment_by_Client_and_Post_Month".  Because of this table name, I am encountering a bug/annoyance when writing a WHERE clause and including an AND... When I hit Tab after typing "and" it incorrectly auto-completes "and" as "Payment_by_Client_and_Post_Month" presumably because it has the word "and" within the name.  Is there a way to omit this table from auto-complete functionality?
Tagged:

Answers

  • Options
    Hi @HWI_Mike

    Thanks for posting.

    If the table is on a different database, you could omit the database from loading suggestions.



    Otherwise I'm afraid it's not possible to do at the moment unless I'm missing anything.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?
Sign In or Register to comment.