I was trying to find some changes I had made to some tables and was having a hard time finding the table I modified.. This helped me find the ones I was last working on ;)

For SQL Server 2005 and up, you can use

SELECT  
[name]  
,create_date  
,modify_date  
FROM  
sys.tables