Autocomplete From User Tables
A nice SQL Prompt feature would be autocomplete using contents from user tables. For example, if I have a smallish table (this idea may be impractical for large tables) with a list of codes - state codes, statuses, categories, etc. - and I need to hard-code a value from the table in a query, it would be cool if SQL Prompt could do autocomplete from the contents of the table.
2
votes
Mark Edgar
shared this idea
-
Thomas Franz commented
Better do NOT hardcode stuff in your table, better add a flag to your status code table that you can use in your query.
Maybe not today and tomorrow, but sometimes in the future you will have another similar exception and would either need to find every occurence of it in your code or simply set the flag on the new status.