title: Change Schema Name Of Table In SQL
body: <p>I want to change schema name of table <code>Employees</code> in Database. In the current table <code>Employees</code> database schema name is <code>dbo</code> I want to change it to <code>exe</code>. How can I do it ? </p>
  
  <p>Example:</p>
  
  <p>FROM </p>
  
  <pre><code>dbo.Employees
  </code></pre>
  
  <p>TO</p>
  
  <pre><code>exe.Employees
  </code></pre>
  
  <p>I tried with this query:</p>
  
  <pre><code>ALTER SCHEMA exe TRANSFER dbo.Employees
  </code></pre>
  
  <p>But this gives me an error:</p>
  
  <blockquote>
    <p>Cannot alter the schema 'exe', because it does not exist or you do not
    have permission.</p>
  </blockquote>
  
  <p>What did I miss? </p>