title: List names of all tables in a SQL Server 2012 schema
body: <p>I have a schema in SQL Server 2012.</p>
  
  <p>Is there a command that I can run in SQL to get the names of all the tables in that schema that were populated by user?</p>
  
  <p>I know a similar query for MySQL <code>SHOW TABLES;</code> but this does not work with SQL Server.</p>