{"id":3481,"date":"2021-07-23T08:55:07","date_gmt":"2021-07-23T15:55:07","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3481"},"modified":"2021-07-25T11:19:07","modified_gmt":"2021-07-25T18:19:07","slug":"how-to-find-new-tables-in-sql-server-with-ssms","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3481","title":{"rendered":"How to Find New Tables in SQL Server with SSMS"},"content":{"rendered":"\n<p><strong>Solution 1 &#8211; First thing to try<\/strong><\/p>\n\n\n\n<p>Try: &#8220;Edit &gt; Intellisense &gt; Refresh local cache&#8221; <\/p>\n\n\n\n<p>Keyboard shortcut: <strong>Ctrl + Shift + R<\/strong><\/p>\n\n\n\n<p>After adding lots of tables, SSMS gets out of sync at times&#8230;<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>Solution 2<\/strong><\/p>\n\n\n\n<p>In this article I&#8217;d like to show you how you can find newly created tables in&nbsp;<strong>SQL Server Management Studio<\/strong>.<\/p>\n\n\n\n<p>First, you need to enable&nbsp;<strong>Object Explorer Details<\/strong>&nbsp;by pressing&nbsp;<strong>F7<\/strong>&nbsp;button or choosing following option from the menu: View &gt; Object Explorer Details.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/dataedo.com\/asset\/img\/kb\/db-tools\/ssms\/ssms_enable_object_explorer_details.png\" alt=\"\"\/><\/figure>\n\n\n\n<p>Now, select&nbsp;<strong>Tables<\/strong>&nbsp;item from the database you want to search. List of tables should be visible on the right side. There should be a&nbsp;<strong>Created Date<\/strong>&nbsp;column that shows when specific table was created in the database. When you double click it will order tables from the newest. Analyze those dates to find newly created tables.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/dataedo.com\/asset\/img\/kb\/db-tools\/ssms\/ssms_new_tables.png\" alt=\"\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Solution 1 &#8211; First thing to try Try: &#8220;Edit &gt; Intellisense &gt; Refresh local cache&#8221; Keyboard shortcut: Ctrl + Shift + R After adding lots of tables, SSMS gets out of sync at times&#8230; Solution 2 In this article I&#8217;d like to show you how you can find newly created tables in&nbsp;SQL Server Management Studio. <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3481\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,625],"tags":[793],"class_list":["post-3481","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-sql","tag-find-new-tables-in-sql"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3481","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3481"}],"version-history":[{"count":3,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3481\/revisions"}],"predecessor-version":[{"id":3485,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3481\/revisions\/3485"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3481"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3481"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}