title: SQL SERVER: Issues with TSQL to check if schema on database exists
body: <p>On SQL SERVER:</p>
  
  <p>I have a schema on my database created using command:</p>
  
  <pre><code>CREATE SCHEMA my-schema AUTHORIZATION [G_USER]
  </code></pre>
  
  <p>When I try search for the schema using the following statement I do not get any result.</p>
  
  <pre><code>SELECT * FROM sys.schemas WHERE name=N'my-schema'
  </code></pre>
  
  <p>However when I try
  <code>SELECT * FROM sys.schemas</code> 
  I get a whole bunch of other schemas but not the my-schema which I created on the database.</p>
  
  <p>Am I doing something wrong? Any Help will be greatly appreciated. <br/>
  Thanks!</p>