How to Find New Tables in SQL Server with SSMS

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.

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

Now, select Tables item from the database you want to search. List of tables should be visible on the right side. There should be a Created Date 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.