PRO TIP: Force table suggestions – Red-Gate SQL Prompt 6

For those SQL Prompt users, like myself, I’m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query window and the table suggestions don’t immediately populate. This can be annoying if you were looking for sys.fulltext_semantic_language_statistics_database, a 50 character long system view name. Thankfully, the SQL Prompt options tells us what to do.

Pro tip: Press Ctrl+Space to manually trigger the suggestions.