{"id":58,"date":"2014-01-23T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/blog\/pro-tip-force-table-suggestions-red-gate-sql-prompt-6"},"modified":"2026-03-18T21:50:48","modified_gmt":"2026-03-18T21:50:48","slug":"pro-tip-force-table-suggestions-red-gate-sql-prompt-6","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2014\/01\/23\/pro-tip-force-table-suggestions-red-gate-sql-prompt-6\/","title":{"rendered":"PRO TIP: Force table suggestions &#8211; Red-Gate SQL Prompt 6"},"content":{"rendered":"<p>For those SQL Prompt users, like myself, I\u2019m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query window and the table suggestions don\u2019t immediately populate. This can be annoying if you were looking for <a href=\"http:\/\/technet.microsoft.com\/en-us\/library\/gg492069.aspx\">sys.fulltext_semantic_language_statistics_database<\/a>, a\u00a050 character long system view name. Thankfully, the SQL Prompt options tells us what to do.<\/p>\n<p><strong>Pro tip:<\/strong> Press <strong><em>Ctrl+Space<\/strong><\/em> to manually trigger the suggestions.<\/p>\n<p><a href=\"\/wp-content\/uploads\/Red-Gate-SQL-Prompt-Force-Suggestions.png\"><img decoding=\"async\" src=\"\/wp-content\/uploads\/Red-Gate-SQL-Prompt-Force-Suggestions.png\" alt=\"\" \/><\/a><\/p>\n<hr \/>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/dh.jpg\" alt=\"\" \/><strong>Written by Derik Hammer of <a href=\"http:\/\/www.sqlhammer.com\/\">SQL Hammer<\/a><\/strong><\/p>\n<p>Derik is a data professional focusing on Microsoft SQL Server. His passion focuses around <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/high-availability\/\">high-availability<\/a>, <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/general\/disaster-recovery\/\">disaster recovery<\/a>, continuous integration, and automated maintenance. his experience has spanned long-term database administration, consulting, and entrepreneurial ventures.<\/p>\n<p>Derik gives the SQL community credit for plugging the gaps in his knowledge when he was a junior DBA and, now that his skills have matured, started <a href=\"http:\/\/www.sqlhammer.com\/\">SQLHammer.com<\/a> as one small way to give back and continue the cycle of shared learning.<\/p>\n<p>Derik is the owner and lead author of SQL Hammer, a <a href=\"http:\/\/www.sqlhammer.com\/\">Microsoft SQL Server resource<\/a>.<\/p>\n<p>For more information, visit <a href=\"http:\/\/www.sqlhammer.com\/\">http:\/\/www.sqlhammer.com<\/a>. Follow Derik on <a href=\"http:\/\/twitter.com\/SQLHammer\">Twitter<\/a> for <strong>SQL tips and chat<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>For those SQL Prompt users, like myself, I\u2019m sure you love its table suggestion feature. Unfortunately, there are situations where you open a query window and the table suggestions don\u2019t immediately populate. This can be annoying if you were looking for sys.fulltext_semantic_language_statistics_database, a\u00a050 character long system view name. Thankfully, the SQL Prompt options tells us [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":524,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-58","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/58","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=58"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/58\/revisions"}],"predecessor-version":[{"id":321,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/58\/revisions\/321"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media\/524"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=58"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=58"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=58"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}