Get List of Tables and Creation Date from SQL Server

Getting information from the SQL Server system tables is relatively easy and can be a great way of checking whether you completed some task or whatever. I use the following query or some variant to see when I’ve done something or what I named it or whatever. SELECT name, create_date FROM sys.tables order by create_date