title: Process to check for new/deleted tables in database
body: <p>Is there any way I can script out the following idea using T-SQL:</p>
  
  <p>I have the start of a script, which identifies tables currently on a database, and their respective row counts, as below:</p>
  
  <pre><code>    SELECT o.name AS 'TableName' ,i.rows AS 'Records'
      FROM sys.tables as o LEFT JOIN sys.sysindexes as i
      ON  i.id = o.object_id 
      WHERE o.type IN ('U')
      AND i.indid in (0,1)
  </code></pre>
  
  <p>But I'd like to set something up where I can flag up any new tables which appear on the database (sort of like yesterday vs today) - also, any that have recently been deleted. Almost acting as a 'table log history'.</p>
  
  <p>So the final output would be a list of all current tables + new + deleted (from yesterday).</p>
  
  <p>Cheers in advance.</p>