How do I change db schema to dbo

Question

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, Jonathan.MovieData. In the table properties, it lists Jonathan as the DB schema. When I write stored procedures I now have to include Jonathan. in front of all the table names which is confusing.

How do I change all my tables to be dbo instead of Jonathan?

Current result: jonathan.MovieData

Desired result: dbo.MovieData

Answer 1

You can change all the tables to be dbo instead of jonathan this way:

ALTER SCHEMA dbo TRANSFER jonathan.MovieData;

For more information, you can refer to ALTER SCHEMA

Generalized Syntax is as follows:

ALTER SCHEMA TargetSchema TRANSFER SourceSchema.TableName;