In this post I show you how to change a schema of your table.

Open Microsoft SQL Server Management Studio, Create new query and past this code

ALTER SCHEMA toschema TRANSFER fromschema.MyTable;

you substitute toschema with your new schema value and fromschema with old schema.

Scenario:
Current result: Jon.Mytable
Desired result: dbo.Mytable
ex:

ALTER SCHEMA dbo TRANSFER Jon.MyTable;

select your instance and click refresh button.

see also:
structure of your db

Advertisements