title: How to "USE" a schema in SQL Server
body: <p>I can do:</p>
  <pre><code>USE db_name;
  </code></pre>
  <p>To have that database be the context. Is there a way to do the same for a schema, so that I can do a CREATE TABLE statement and it will automatically be placed within that schema?</p>
  <pre><code>CREATE TABLE jobs( -- insted of CREATE TABLE myschema.jobs
      job_id INT PRIMARY KEY IDENTITY,
      customer_id INT NOT NULL,
      description VARCHAR(200),
      created_at DATETIME2 NOT NULL
  );
  </code></pre>