Find recently created tables in Azure SQL database

Query below lists all tables in Azure SQL 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

0
There are no comments. Click here to write the first comment.