When it comes to managing databases, SQL Server Management Studio (SSMS) is a powerful tool that offers various options to simplify tasks. In a previous blog post, I discussed a T-SQL method to find tables created last week. However, many of you have reached out to me asking if there is an easier way to achieve the same result using the SSMS user interface.
Today, I will share two alternative methods within SSMS that can help you quickly identify the tables created within a specific timeframe.
Method 1: Object Explorer
Using the Object Explorer in SSMS, you can easily filter the tables based on their creation date. Here’s how:
- Navigate to the Tables node in the Object Explorer.
- Right-click on the Tables node and select “Filter” followed by “Filter Settings”.
- In the filter settings, you will find a “Creation Date” property. Specify the desired date condition using the available operator and value options.
- Click “OK” to apply the filter.
By following these steps, the Tables node in the Object Explorer will be filtered to display only the tables created within the specified date range.
Method 2: Object Explorer Details Pane
Another option is to utilize the Object Explorer Details Pane, which can be accessed using the F7 shortcut. This method allows you to sort the tables based on their creation date. Here’s how:
- Open the Object Explorer Details Pane using the F7 shortcut.
- In the header of the pane, locate the “Create Date” column.
- Click on the “Create Date” column header to sort the tables based on their creation date.
By sorting the tables in this manner, the tables created most recently will appear at the top of the list.
These two methods provide quick and convenient ways to identify the latest tables created in your database without the need to write any T-SQL queries. However, if you have any other techniques or insights on this topic, I would love to hear from you and learn from your experiences.
Thank you for your continued support and stay tuned for more SQL Server tips and tricks!