title: Query that returns all tables that don't contain a particular column
body: <p>Here is the simple sql query that will return all tables that have the following column name, 'userid' or 'user_id'.</p>
  
  <pre><code>SELECT  t.name 
  FROM sys.tables t
  INNER JOIN sys.columns c ON t.object_id = c.object_id
  WHERE c.name LIKE 'userid' OR c.name LIKE 'user_id'
  ORDER BY name
  </code></pre>
  
  <p>However, what I would like to do here is to get all the tables that <strong>don't contain</strong> 'userid' column and 'user_id' column. How should I query this? </p>
  
  <p>P.S. Using <strong>NOT LIKE</strong> will still bring back the table that contains 'userid' or 'user_id' column, if the table has some other different columns. </p>
  
  <p>Thanks very much.</p>