title: what is the significance of schema name in SQL server
body: <p>I am new to SQL Server. I connected to SQL server via SQuirrel Client.</p>
  
  <p>Connection URL:</p>
  
  <pre><code>jdbc:sqlserver://192.xx.xx.xx:1433;databaseName=ep
  </code></pre>
  
  <p>with <strong>username</strong> &amp; <strong>password</strong>.</p>
  
  <p>Then I tried a query on <code>table1</code> in <code>schema1</code> - </p>
  
  <pre><code>SELECT * from table1 
  </code></pre>
  
  <p>It returned records. I did not mention schema name in query.</p>
  
  <p>There may be possibility of having tables in different sachems (<em>same database</em>) <strong>with same name</strong>. </p>
  
  <p>Am I right? If yes, then how will it resolve schema name?</p>