title: How do I change db schema to dbo
body: <p>I imported a bunch of tables from an old sql server (2000) to my 2008 database.  All the imported tables are prefixed with my username, for example: <code>jonathan.MovieData</code>.  In the table <code>properties</code> it lists <code>jonathan</code> as the db schema.  When I write stored procedures I now have to include <code>jonathan.</code> in front of all the table names which is confusing.</p>
  
  <p>How do I change all my tables to be dbo instead of jonathan?</p>
  
  <p>Current result: <code>jonathan.MovieData</code></p>
  
  <p>Desired result: <code>dbo.MovieData</code></p>