To find tables, stored procedures in sql database
SELECT A.name AS [Object Name], S.[name] [Schema Name], A.type_desc [Description], A.create_date [Creation Date], A.modify_date [Modified Date] FROM sys.all_objects A LEFT OUTER JOIN sys.schemas S ON A.schema_id = S.schema_id WHERE create_date > (GETDATE() - 15) OR modify_date > (GETDATE() - 15)
It help me to find table name created by me.