Query to find tables created in the last hour

I want to find out which tables have been created in the last hour in a MS SQL Server database. How can I do this?

Answer

You can query sys.tables.

SELECT
    T.*
FROM
    sys.tables AS T
WHERE
    T.create_date >= DATEADD(HOUR, -1, GETDATE())

Will just give you results of the currently connected database.