I imported a lot of tables from a classic sql server (2000) to my 2008 database. All of the imported tables are prefixed with my username ex: jonathan.MovieData. Within the table qualities it lists 'jonathan' because the db schema. After I write saved methods I are in possession of to incorporate 'jonathan.' before all of the table names that is confusing.

How do you change my tables to become dbo rather than jonathan?

Current result: jonathan.MovieData

Preferred result: dbo.MovieData

ALTER SCHEMA dbo TRANSFER jonathan.MovieData;

See ALTER SCHEMA.

USE MyDB;
GO
ALTER SCHEMA dbo TRANSFER jonathan.MovieData;
GO

Ref: ALTER SCHEMA

You are able to run the next, that will generate some ALTER sCHEMA claims for your talbes:

SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'jonathan'

After this you need to copy and run the claims in query analyzer.

Here's a mature script that is going to do that for you personally, too, I believe by altering the item owner. Haven't attempted it on 2008, though.

DECLARE @old sysname, @new sysname, @sql varchar(1000)

SELECT
  @old = 'jonathan'
  , @new = 'dbo'
  , @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
      AND TABLE_SCHEMA = ''' + @old + '''
  )
  EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

EXECUTE sp_MSforeachtable @sql

First got it from this website.

Additionally, it discusses doing exactly the same for saved procs if you want to.

Method of doing it for a person factor:

alter schema dbo transfer jonathan.MovieData

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/0a760138-460e-410a-a3c1-d60af03bf2ed.htm

ALTER SCHEMA schema_title TRANSFER securable_title