Omit a specific table from auto-complete
HWI_Mike
Posts: 1 New member
in SQL Prompt
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
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.
Tianjiao Li | Redgate Software
Have you visited our Help Center?