Below are few useful sql server commands that can help and ease our SQL Server experiences.
SELECT name, crdate FROM SYSOBJECTS WHERE xtype = 'U'; GO
Find a list of user-created tables (thus ignoring system tables).