Query below lists all tables in SQL Server database that were created within the last 30 days

Query

select schema_name(schema_id) as schema_name,
       name as table_name,
       create_date,
       modify_date
from sys.tables
where create_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)
order by create_date desc;

Columns

• schema_name - schema name
• table_name - table name
• create_date - table creation date
• modify_date - last update time of table (by ALTER statement)

Rows

• One row represents one table in a database
• Scope of rows: all tables in database that were created within the last 30 days
• Ordered by create datetime

Sample results