forum

Home / DeveloperSection / Forums / In sql server 2005, how do I change the “schema” of a table without losing any data?

Ask Question

In sql server 2005, how do I change the “schema” of a table without losing any data?

Pravesh Singh219206-May-2013
Hi All!


I have a table that got into the "db_owner" schema, and I need it in the "dbo" schema.

Is there a script or command to run to switch it over?

Thanks in advance!
mssql servermssql server 
Updated on 06-May-2013
Pravesh Singh

Pravesh Singh

Follow
Student

Can you answer this question?

Answer

1 Answers

AVADHESH PATEL

AVADHESH PATEL

06-May-2013
Hi Pravesh!

In SQL Server Management Studio:

Right click the table and select modify (it's called "Design" now)
On the properties panel choose the correct owning schema.

Liked By