{"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

Solution 1 – First thing to try<\/strong><\/p>\n\n\n\n

Try: “Edit > Intellisense > Refresh local cache” <\/p>\n\n\n\n

Keyboard shortcut: Ctrl + Shift + R<\/strong><\/p>\n\n\n\n

After adding lots of tables, SSMS gets out of sync at times…<\/p>\n\n\n\n

<\/p>\n\n\n\n

Solution 2<\/strong><\/p>\n\n\n\n

In this article I’d like to show you how you can find newly created tables in SQL Server Management Studio<\/strong>.<\/p>\n\n\n\n

First, you need to enable Object Explorer Details<\/strong> by pressing F7<\/strong> button or choosing following option from the menu: View > Object Explorer Details.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Now, select Tables<\/strong> item from the database you want to search. List of tables should be visible on the right side. There should be a Created Date<\/strong> 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>\n","protected":false},"excerpt":{"rendered":"

Solution 1 – First thing to try Try: “Edit > Intellisense > Refresh local cache” Keyboard shortcut: Ctrl + Shift + R After adding lots of tables, SSMS gets out of sync at times… Solution 2 In this article I’d like to show you how you can find newly created tables in SQL Server Management Studio. 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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t